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 » Best Practices   (RSS)
Differences between ISNULL and COALESCE
I came across a question in the SQL Server MVP newsgroup recently about ISNULL and COALESCE usage. COALESCE basically translates to CASE expression and ISNULL is a built-in implemented in the database engine. Both ISNULL and COALESCE can be used to get Read More...

Posted Thursday, June 26, 2008 8:55 PM by SQL Server Engine Team | 7 Comments

Filed under: ,

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

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

Renaming sa account in SQL Server 2005
Renaming sa account in SQL Server 2005 Read More...

Posted Saturday, August 27, 2005 1:44 PM by SQL Server Engine Team | 10 Comments

Getting SQL Server registry settings via SQLCLR table-valued user-defined function...
SQLCLR TVF to read registry settings for SQL Server instance Read More...

Posted Friday, August 19, 2005 4:47 PM by SQL Server Engine Team | 2 Comments

Feedback requested on database mirroring...
Database Mirroring configuration using certificate authenticated endpoints. Read More...

Posted Thursday, July 28, 2005 9:43 PM by SQL Server Engine Team | 10 Comments

Ordering guarantees in SQL Server...
Ordering guarantees in queries. Read More...

Posted Wednesday, July 20, 2005 11:20 AM by SQL Server Engine Team | 18 Comments

Filed under: ,

Using ANSI SQL style DECLARE CURSOR statement in UDF...
Use of ANSI SQL style DECLARE CURSOR statement in UDF is not supported Read More...

Posted Tuesday, June 21, 2005 9:09 PM by SQL Server Engine Team | 4 Comments

Filed under:

Performing batched updates...
Performing updates in batches using UPDATE with TOP clause. Read More...

Posted Tuesday, May 31, 2005 6:56 PM by SQL Server Engine Team | 0 Comments

Page view tracker