Thanks very much to you and Lowell for taking time to do this, and for publishing your efforts.  Again, no complaints about perf.  Even if I fail to improve it,...

Not complaining, just an FYI for those who were alarmed by three minute duration...

I tested it on a QA VM and it ran 10 minutes. 
"A man's got...

I have the same issue with SQL 2008 R2 SP3, and found a KB about passing parameters to the self-extractor. http://support.microsoft.com/kb/912203

It didn't behave as it says, but...

In the initial CREATE TABLE example, [RowNum] should be [EmployeeId].

Thanks for the great article.

Mine was caused by name collision between two processes both using instances of the DTS "Copy SQL Server Objects Task" component. It scripts objects to the folder mentioned above,...

This happened to me running SQL2000 under VMWare, running a backup with RedGate HyperBac 5.7.0.155 as the transparent compression. The backup had hung (which has happened twice on this,...

Some unsolicited advice from my bad experience. Save the before and after image of your work and have it reviewed by someone familiar with your business systems. Data-fixes often...

Embedded images http://www.sqlservercentral.com/articles/2901/DataWa1.jpg and http://www.sqlservercentral.com/articles/2901/DataWa2.jpg are 404 when I look at this article, or if I try to hit them directly.

Microsoft made the right decision to minimize the attack surface by default, and let DBAs open known vulnerabilities through configuration rather than install misunderstood vulnerabilities by default.

When I...

When I ran into this question a few years ago while working for Microsoft, the answer was "Microsoft does not have a story for replication from Oracle to SQL 2000...

I heard from an instructor that Microsoft had de-emphasized that feature (removed it as a default) because it eventually causes EM to crash and they needed the dev resources for...

Your problem description has only one example, so I'm not sure this will help, but...

You could maintain a copy of the TEXT column, which has been stripped of all the...

Maybe someone is injecting code.  It appears vulnerable to that, and would safer if you used proper SQL parameters instead of string-concatenation.   

Most likely someone is using leading wildcard-characters on the LIKE...

Sounds like you are either missing clustered indexes, or your foreign keys aren't indexed, or your indexes are badly fragmented.  If DBCC SHOWCONTIG doesn't identify any fragmented indexes to rebuild,...