New whitepapers on physical database storage and tempdb…

Below are links to two new whitepapers from the storage engine team. Please check it out to get better understanding of the new features in SQL Server 2005 and enhancements.   Working with TempDBhttp://download.microsoft.com/download/4/f/8/4f8f2dc9-a9a7-4b68-98cb-163482c95e0b/WorkingWithTempDB.doc Physical Database Storagehttp://download.microsoft.com/download/4/f/8/4f8f2dc9-a9a7-4b68-98cb-163482c95e0b/PhysDBStor.doc

0

Troubleshooting deadlocks in SQL Server 2005

SQL Server 2005 adds new capabilities to troubleshoot deadlocks. I talked about the new trace flag #1222 in a previous post. The blog entry below from the SQL Server Storage Engine team talks about the new trace flag and provides some examples on how to use the new output. http://blogs.msdn.com/sqlserverstorageengine/archive/2006/06/05/617960.aspx

0

Use of SCHEMABINDING option for TSQL UDFs can improve performance in SQL Server 2005…

SQL Server 2005 has new optimization logic to use the SCHEMABINDING option to derive certain properties about the TSQL UDF. This can greatly improve performance of queries that use scalar UDFs in a SELECT statement for example. You can read all about it at the blog entry below from one of  our development engineers. http://blogs.msdn.com/sqlprogrammability/archive/2006/05/12/596424.aspx

2