SQL Server Engine Tips

Guidelines, Best Practices, TSQL and SQL Programming Tips & Tricks.

This Blog

About
Email

Syndication

Search

News

These postings are provided
"AS IS" with no warranties,
and confers no rights.
Use of included script samples
are subject to the terms
specified at http://www.microsoft.com/ info/cpyright.htm.

SQL Server 2005

SQL Server Document Links

Browse by Tags

All Tags » Best Practices » SQL Server 2005 (RSS)

Determining optimal MAXDOP setting from TSQL in SQL Server 2005

Determing optimal MAXDOP setting value using DMV Read More...

Posted Wednesday, September 14, 2005 12:02 PM by SQL Server Engine Team | 10 Comments

Filed under: SQL Server 2005, Best Practices, Dynamic Management View

Renaming sa account in SQL Server 2005

Renaming sa account in SQL Server 2005 Read More...

Posted Saturday, August 27, 2005 1:44 PM by SQL Server Engine Team | 10 Comments

Filed under: SQL Server 2005, Best Practices

Getting SQL Server registry settings via SQLCLR table-valued user-defined function...

SQLCLR TVF to read registry settings for SQL Server instance Read More...

Posted Friday, August 19, 2005 4:47 PM by SQL Server Engine Team | 2 Comments

Filed under: SQL Server 2005, Best Practices

Feedback requested on database mirroring...

Database Mirroring configuration using certificate authenticated endpoints. Read More...

Posted Thursday, July 28, 2005 9:43 PM by SQL Server Engine Team | 10 Comments

Filed under: Architecture, SQL Server 2005, Best Practices

Performing batched updates...

Performing updates in batches using UPDATE with TOP clause. Read More...

Posted Tuesday, May 31, 2005 6:56 PM by SQL Server Engine Team | 0 Comments

Filed under: SQL Server 2005, Best Practices