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