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
10,488 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,025 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-04-07 (first published: 2009-03-02)
1,246 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.
2007-03-30 (first published: 2007-03-08)
613 reads
Blogs
Stellar Toolkit for MS SQL - Software Review
By nelsonaloor
As a SQL database administrator, I am responsible for maintaining our organization's SQL Server...
Behavior of numeric data types with ”
As we all know, there are various numeric data types, such as TINYINT, INT,...
Daily Coping 5 Mar 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Alert configuration
How to set up alerts on long running jobs on sql server ?, pls...
Help with procedure creation and execution
I created the procedure below, but the updates do not run, how do I...
Data Warnings / Ignore Checked Results
Not looking for any code, just ideas. I have a series of queries which...
Ask SSC