Topics
Started by
Posts
Last post
Hi, we had case today where query with index seek provided much worst performance c…
4 replies
Hi all I've got a table that contains 1.8million (yes, million) records in a parent/child re…
7 replies
How can I avoid use cursor to implement the following? I read that it can be done with CTE but I di…
9 replies
By: scdecade
We've got an old Microsoft Access pharmacy application which acts as a front-end to a SQL Server 20…
12 replies
Hello all, I have a dataset of trip information (the majority of which I got from another awesome f…
8 replies
Hi all, Please consider the following table structure. CREATE TABLE [dbo].[Transactions]( [Id] [in…
2 replies
Hi I have set of hundreds of business rules that I need to executed based on certain criteria. Just…
1 replies
I have a fact table with two numeric columns defined as DECIMAL(28, 12) and I am attempting to load…
10 replies
Hi, using Merge I can sync table A with Table B at ROW level. However 'how to update only specific …
1 replies
Hi, I want a range of values between a start number and end number say 10000 to 50000 using SQL, bu…
3 replies
I tried many different ways and built a function to basically go character by character checking th…
2 replies
Hi all, I need your help. I need passing variable into xp_cmdshell. This is my code : DECLARE @cmd…
6 replies
I know that this is a long article, so, I totally understand if there are no replies. This seemed l…
3 replies
In the attached Stored Procedure, the yellow-highlighted code causes major blocking, especially whe…
21 replies
I m trying to set Mirroring in MS SQL Server 2016. Everything looks fine still mirroring is failing…
1 replies
Viewing 15 topics - 1 through 15 (of 2,045 total)
You must be logged in to create new topics.