The script Lowell referenced appears flawed.  It gave me incorrect results.

This script creates the truncate/delete commands in order with respect to foreign keys as Dan requested, but I think Frank's...

There is no way to modify a trigger or index to change the table it is associated with, you have to drop the old ones and create new ones on the...

You can cut & paste from Query Analyzer in grid mode, but you lose the column headings.

You can cut & paste from QA in text mode/column aligned, but you have...

I've been too busy to read my email lately, but I'll take another shot at enlightening you.

First, the problem with the formula "IntegerField / 22" in T-SQL is you will have...

A truncate command is not logged, so it is very fast. But it deletes the entire table.

If you want to delete a large fraction of the table, and realize...

Orphaned role members that aren't users or logins? Orphaned users from a database copy are usually entries in sysusers that are missing from master..sysxlogins, or have a different sid...

Have the DTS package create a log file so you can see the offending data.

I've had so many problems with importing illegal date values from a Teradata system that I...

sp_spaceused uses the numbers from sysindexes, so it will be just as inaccurate. sysindexes can be seriously inaccurate. Ever see databases with negative free space? I just...

I manage several SQL Servers with 100GB - 600GB databases. Obviously the hardware has to be up to the task. You're not going to get Oracle to do it...

You can't help but love a product that makes you look good.

And no, I am not associated with Quest in any way and am not being compensated for this post.

I've seen Veritas' product, it is very impressive but pricey. I bought Quest's Spotlight on SQL Server earlier this year and I'm very happy with it. I've heard...

If procperiod is the first field in the clustered index, I would think it should always use an index seek. I'm assuming it isn't the first field.

Either the data...

I'm going to repost this solution because a) the other solutions are still using row-based logic and, even worse, dynamic SQL for every row; and b) I don't think...

I must have missed the part where he said his VB6 app ran under IIS.  A standalone VB6 app won't use connection pooling.

You should minimize the number of times a...

I forgot to mention the issue of having to rewrite all your code for each new release of SQL Server, maybe even for each service pack.