SQL Server Engine Tips

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

Browse by Tags

Tagged Content List
  • Blog Post: 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, 1 AS treelevel FROM Employees WHERE (Employees...
  • Blog Post: 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...
Page 1 of 1 (2 items)