Welcome to MSDN Blogs Sign in | Join | Help

SQL Server Engine Tips

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

Syndication

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.

Browse by Tags

All Tags » SQL Server 2005 » Dynamic Management View   (RSS)
OBJECT_NAME enhancement and OBJECT_SCHEMA_NAME addition in SQL Server 2005 SP2
SQL Server 2005 SP2 has an important enhancement to OBJECT_NAME metadata function and a new OBJECT_SCHEMA_NAME metadata function. I will first describe the old functionality to give some context and demonstrate how the new features help a lot. Please Read More...

Posted Friday, March 23, 2007 4:24 PM by SQL Server Engine Team | 2 Comments

Find Top N costly query plans in adhoc batches or modules...
Top N costly query plans Read More...

Posted Wednesday, October 05, 2005 6:03 PM by SQL Server Engine Team | 12 Comments

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

Page view tracker