Apex has updated their SQL Diff tool. Their product info page doesn't yet mention it, but their sales staff pointed me to the download page which references the new version,...

Microsoft commented on this issue in May 2003 during Q&A session, indicating that there's not much you can do.

They suggested, in a seperate MSDN post, using a third-party compression tool...

You have GROUP BY Supplier, Invoice, yet you are only displaying a portion of the invoice number. If the rest of the invoice number contains differences, it will generate separate...

The best thing to start with is probably "sp_who" or "sp_who2". That will at least show you what processes are running in SQL and whether there is any blocking going...

There's a tool from Red Gate which does that:

http://www.red-gate.com/products/sql_compare/index.htm

From what I've been able to understand from the literature, AWE was *necessary* to access certain amounts of memory in 32-bit versions. 64-bit versions allow access to that large amount...

Thanks for your insight. We'll probably go with the RAID 10, but...

If you have RAID 10, can you add two more drives to increase capacity later without destroying the array...

Aren't procs stored in syscomments? Would edits to syscomments be logged in the same way as edits to normal tables are? Would a 3rd-party tool which allows a user to...

I think the "N" causes it to convert the text to nvarchar, which is a different data type than your clustered field. That's probably why it's not using the clustered...