Error while trying to update Always Encrypted column using a stored procedure
In our development environment, one dedicated machine is set as SQL Server Database server. All other development machines are connected to this server as clients using SQL Server Management Studio. Facing some issues after implementing "Always…
Query stuck with HTDELETE for hours eventually timing out
We have an Azure SQL Database to manage our Customer data. I have a reasonably complicated query that has been getting stuck with an HTDELETE wait. Most recently it timed out after 4 hours. This was in our QA environment. The same query finishes in less…
SQL Statement taking long to execute
I have two SQL Databases that is on the same SQL server but on one database it only takes 4 seconds to complete the SQL statement but on the other SQL database it takes 25 minutes to complete. Both databases uses the same SQL elastic pool and I don't see…
How to figure out the total number of doses within a time span given to a client as dose are being added and stopped.?
If the cadence values are different, even if the dates overlap the records must be separate. If an order for the same dose and cadence value (including nulls) starts on the same day or the next day (+or-1 day) the record should continue. outlook of…
Trying TDE CMK with Azure key vault
CREATE ASYMMETRIC KEY EKMSampleASYKey FROM PROVIDER [AzureKeyVault_EKM] WITH PROVIDER_KEY_NAME = 'keyname', CREATION_DISPOSITION = OPEN_EXISTING; throwing the below error Key with name 'keyname' does not exist in the provider or access is denied.…
SSIS : Decimal Places not loading from Excel Source to SQL table
Hi Team - I have an excel file with few columns but the issue is with one of the column, Lets say Column A. Column A : FY20 Work Extra Feb 4 4,401,0089 3,81,68182.01 27,381.59 - 42590062.77 99.8% Few of the numeric values above are rounding off in…
how to see the effect of Enable Scalar UDF Inlining in query plan
hi, i read this artical https://learn.microsoft.com/en-us/sql/relational-databases/user-defined-functions/scalar-udf-inlining?view=sql-server-ver16 but could not reproduce the following results , is ther any query or example on interent where i can see…
SQL Server 2019 - 100% CPU and high waits after job execution
We have a job running on our SQL Server 2019 which is calculating some customer statistics. Every now an then, after the job finished, the CPU usage increases to the maximum and is not resolving until a failover to the secondary node is done. The job…
Faster way to data load from oracle to SQL server without Attunity 5.0
Hello, I am in the process of upgrading SSIS packages from 2015 to 2022 using VS 2022. we are having performance issues with data load from oracle to SQL and vice versa. we were using Attunity 4.0 with previous version of VS 2015 and that was a big help…
Help in SQL Conversion query
How I can convert Total column from varchar to numeric to show result in numeric with two decimal using SELECT query. Create table #temp (Num1 numeric (6,2), Num2 numeric (6,2), Num3 numeric (6,2), Num4 numeric (6,2), Total varchar(200)) insert into…
Slow queries to INFORMATION_SCHEMA after upgrade to SQL 2022
Hello! We have a Microsoft SQL Server 2022 (RTM-CU12-GDR) (KB5036343) - 16.0.4120.1 (X64) Mar 18 2024 12:02:14 Copyright (C) 2022 Microsoft Corporation Developer Edition (64-bit) on Linux (Ubuntu 22.04.4 LTS) <X64> We are selecting a scalar…
ID's coming back as nulls are not appearing in my data set
I am trying to create a, intergrity check that bring back data after a record has been cancelled after a certain event. In my query. I am joining to a few tables and I can see all the old cancelled record. When I then cancel any new records, some IDs I…
Upgrading SQL Server having multiple instances
Our SQL is of 2014 RTM. Planned to upgrade it to 2014 SP3 in the first place later to 2022. And our SQL Server do have extra 2 instances as being used for replication DBs. I saw rolling upgrade as solution to HA environment. But nowhere could I see…
SQL Server Licensing
Hi Team, My customer has SQL server 2017 Enterprise licensing. He needs to upgrade the SQl server to 2022. Is he able to use the Existing License for SQL 2022 and he doesn't have Software assurance.
Partition by filter
Hey Team I have table where A values comes then E value should be filter or else E value should be there partition by data and mpr column expected values
Towards upgrading SQL 2014 to 2019
We are brim of making upgrading Windows Server as well as SQL Server. Currently we are having SQL 2014 RTM, Enterprise Edition in Windows Server 2012 R2 We purchased license for SQL 2022, Enterprise Edition and on process of purchasing license for…
Set up valuable Indexes on a table
I have a really big transaction table, billions of rows, and I need some kinds of Indexes to make it useful. Right now there is a clustred columnstore index on the table, and a nonclustred on ID, but I guess I need some nonclustred to make the table…
SQL Server wrongly using Inner Join instead of Left join.
I am working on SQL Server version 2019 with compatibility mode = 150. There is a scenario where I am using two tables TableA & TableB. Where I have to pull records which are not present in TableB but present in TableA. So I have created a simulation…
SQL Server Non Clustered Index CREATE taking forever to cancel
I ran a CREATE NON CLUSTERED INDEX command for 1.5 hours. Decided to cancel it because it was stopping other things running. The command has now been running for 22 hours. What is it doing that takes so long to roll back? The table is 2 billion rows and…
delimited split gives null for some items
hi all, I am using a function to split a string into multiple rows. The function is available here: https://www.sqlservercentral.com/articles/tally-oh-an-improved-sql-8k-%e2%80%9ccsv-splitter%e2%80%9d-function What I am trying to figure out is how to…