SQL Server Engine Tips

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

This Blog

About
Email

Syndication

RSS 2.0
Atom 1.0

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

Top 30 Features
.99 US $ TPC-C price/performance benchmark
Features Comparison by Edition
Upgrade Resources
SQL Performance

Browse by Tags

All Tags » Best Practices » Performance - SQL/TSQL (RSS)

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