It seems obvious that it would be faster in single-user mode, but I don't know how you would estimate the time difference with no test system.

Have you tried profiling the system...

1 cubic foot = 28317 cubic centimeters.

I think showing all objects and their owners is overkill.

This will find all objects in all databases owned by a given login:

set

nocount on

create...

I agree that someone needs to have database normalization explained to them (loudly and at length), but I'll take a shot at answering your question. 

If you define the constraint...

The rowcnt field in sysindexes will give you a rowcount:

    select object_name(id), rowcnt from sysindexes where indid < 2

This is frequently inaccurate, although it's usually a good estimate.  If you...

Bulk insert is the fastest way to load data into SQL Server, especially if it is minimally logged.  The data source can only be a text file.

The fastest way to...

Did you try their website?  http://www.quest.com/quest_central_for_sql_server/index.asp

I don't think it has what I would call a debugger.  It can do wonderful things to help you improve and optimize working SQL...

The bulk insert will undoubtedly be much faster than using transforms, but an important question is what kind of transforms?  If you are modifying data in transforms, then these operations...

A 10-digit phone # could overflow an int, but casting to bigint, dec(10,0), or char(10) would be safe.  STR(phone,10,0) would also work.

Backup history is not deleted automatically, you should periodically run sp_delete_backuphistory to clean it out.

That stored proc can take a long time to run because it uses cursors, especially if...

The inserts will be logged regardless of whether row locking or table locking is used.

If this is a serious problem, you might consider these approaches:

Dump the data warehouse records to...

The table lock option controls whether row locking or table locking is used for the destination table.

If the source is a table (rather than a text file, spreadsheet, etc.), it...

There are some great webcasts available (both live and on-demand) from Microsoft at this site: http://www.microsoft.com/events/series/msdnsqlserver2005.mspx#On-Demand%20Webcasts

Indexes and fragmentation are discussed in parts 4 and 5 of a 10-part "A primer...

I thought your original point was that a clustered index would require more pages to store the non-leaf part of the index due to the higher leaf-level page count, which...

It is true that there will be more index entries in a clustered index due to the larger number of leaf-level pages, but this adds at most one level to...