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,808 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,120 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,265 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)
623 reads
Blogs
When It’s Still Viable
By Brian Kelley
If a technology is still viable, don’t overlook it. Don’t get caught up chasing...
T-SQL Tuesday #179: The Detective’s Toolkit
By Steve Jones
It’s time for the monthly T-SQL Tuesday blog party. This month a longtime friend,...
Moving T-SQL Tuesday to Jekyll
By Steve Jones
I got a message a few months back that Microsoft was deprecating the MySQL...
Forums
Azure SQL DB CLR
Hi, Azure SQL DB doesn't support CLR, if we have an application with CLR...
Steps to restore database which is part of Trans replication and Allwayson db
We have a Setup where replication and AG is configured as below. Servers:Node1,Node2 ==>Node1...
An error occurred while skipping data rows
I am trying to build an ETL for an Existing Table. The ETL (SSIS)...
Question of the Day
Data Migration Assistant Targets
In the current (2024) version of the Data Migration Assistant, which on-premises targets are available?
See possible answers