Please read "Forum Etiquette: How to post data/code on a forum to get the best help"

http://www.sqlservercentral.com/articles/Best+Practices/61537/

NOLOCK is the same as READUNCOMMITTED:

From BOL:

Specifies that dirty reads are allowed. No shared locks are issued to prevent other transactions from modifying data read by the current transaction, and...

Here is some SQL to get all of the database properties and has been tested with both 2000 and 2005 with various collatations. The SQL is different for SQL...

Promotional activities are those that advance software thru the various phases such as usability testing, functionallity testing, performance testing and finally to productions.

For the US, the Sarbanes-Oxley Act titled...

As I used live production data and sp_spaceused reports about one and half million rows and 256Mb of space used, posting that much data is not possible.

I have sent Paul Nielsen an email letting him know about the WareZ site.

This message is related to the network.

Check the NIC setting on both servers and insure that "link speed & autodetect" is NOT "auto-detect" and that the other parameters are...

This SQL should work from the master database:

alter database carl_test

set offline with rollback immediate

restore database carl_test

from disk = 'r:\carl_test.bak'

with replace

See http://support.microsoft.com/kb/307487#6 for why you should not shrink tempdb while in-use:

Effects of Execution of DBCC SHRINKDATABASE or DBCCSHRINKFILE While Tempdb Is In Use

If tempdb is in use and you attempt...

Just to add a practical reason why the data model is poor, trying adding a uniqueness constraint on Product.book_isbn. Since the value will be null for all of...

PAGELATCH_EX indicated waits for physical I/O

CXPACKET indicates waits for parallel processes to complete.

NETWORKIO indicates waits for Network I/O

For NETWORKIO, use perfmon to determine the workload and if there is sufficient...

Please read "Why should I consider using an auxiliary calendar table?" at

http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-calendar-table.html

Regarding you question "When creating databases to use 'sa' or N'Domain\Administrator' user credentials or a separate [dbo] sql account?"

My answer is none of the above.

Security best practices dictate that logins...

Under SQL Server 2000, space usage is not maintained in real time and you must run "dbcc updateusage" with appropriate parameter values to get the correct information.

For a Temporal Project, where the project includes all of the primary key columns, benchmarks of three SQL Server solutions were performed and documented below. The three different solutions were...