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 » Performance - SQL/TSQL (RSS)

Spool operators in query plan...

I came across a question in the relationalserver.performance newsgroup where a customer was wondering about the spools seen in a recursive query execution plan. The query is shown below: USE Northwind; Go WITH EmpChart AS ( SELECT EmployeeId, ReportsTo, Read More...

Posted Thursday, August 30, 2007 12:38 PM by SQL Server Engine Team | 2 Comments

Filed under: Performance - SQL/TSQL

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 Read More...

Posted Monday, June 12, 2006 3:04 PM by SQL Server Engine Team | 2 Comments

Filed under: Best Practices, Performance - SQL/TSQL