Parallel Processing
Satish More brings us a framework that you can use to execute a number of jobs in parallel and finish a task quickly.
2009-10-12
11,871 reads
Satish More
Gain Space Using XML data type
This article is an attempt to explain the application of new XML support in SQL Server 2005 for efficient data storage and performance.
2009-08-04
4,141 reads
SQL 2000: Track Stored Procedure Changes
SQL Server 2000 does not log the procedures modified using ALTER statement. Here's the script to find out the same.
2009-07-06 (first published: 2009-03-02)
1,269 reads
Code Comparison between two databases
This script compares the code (SP, Func. etc.) between two databases (say Dev and QA) and reports the objects which have differences.
2009-02-26 (first published: 2007-03-08)
624 reads
Blogs
Join me at the Microsoft Fabric Community Conference with a discount code
I’m excited to be speaking at the Microsoft Fabric Community Conference this year, which...
Is Your Business Truly Ready for AI?
The AI revolution isn’t coming – it’s here. Companies are racing to integrate artificial...
Data Governance: The Invisible AI Accelerator
Introduction Do you remember the effort of tidying up your BI and reporting systems,...
Forums
MSDTC not available on Windows 2022 clustered SQL 2019 CU30
I connect to this clustered instance and run : begin distributed transaction Msg 8501,...
Time Outs Here
Several times in the last couple of days I've had submissions time out with...
Data Diagrams: Data Types with Column Names
In the ss below I highlighted several rows in each block showing tables in...
Question of the Day
Counting Bits III
What is the output of this code in SQL Server 2022?
select bit_count(0xEF)See possible answers