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,286 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,060 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,257 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)
618 reads
Blogs
Is Cataloging Your Data Important?
By Chris Yates
Data continues to be the lifeline for companies across the globe. As maturity levels...
Daily Coping 20 Mar 2023
By Steve Jones
Today’s coping tip is to get outside and notice how the weather feels. This...
Tales From The Field Weekly Wrap Up for the Week of 03-13-2023 & SQLBits 2023
By SQLBalls
Hello Dear Reader! What an incredible week we had. I started off traveling on...
Forums
Azure SQL - Restore to lower enviornment
Hello! Backups are automated for Azure SQL Prod environment, we can do point-in-time recovery...
Bcp queryout issue
Hi all, I am running the following query in SQL, trying to export some...
SQL Server RLS Database Users and Login User Permission
Please suggest practice on SQL Server RLS On the database level, defined users with...
Ask SSC