SQL Server Engine Tips

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

Browse by Tags

Tagged Content List
  • Blog Post: 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 the same results but there are some differences...
  • Blog Post: DATALENGTH optimizations for LOB data types...

    DATALENGTH function in TSQL can be used to find the actual length in bytes of the data in a specific value. The value can be any of the data types. It is often used to determine length of LOB data type columns (text, ntext, image, varchar(max), nvarchar(max) and varbinary(max)) in a table. One of the...
  • Blog Post: Top 5 SQL/TSQL/Engine features summary of responses...

    You can find below the summary of responses for the top 5 features requested for next version of SQL Server. http://umachandar.members.winisp.net/files/top_5_features_summary.htm You can post your requests on the blog at http://blogs.msdn.com/sqltips/archive/2005/10/07/top_5_features_request...
  • Blog Post: Renaming logins in SQL Server 2005...

    Did you know that SQL Server 2005 supports renaming logins? This can be done via ALTER LOGIN statement. I posted a sample about renaming sa login and disabling it before. But it is probably not obvious if you can do it for all logins. Ex: ALTER LOGIN sqluser WITH NAME = [newuser]; You can also...
  • Blog Post: SQL Server 2005 features that are dependent on Windows Server 2003...

    The question about what features are supported by SQL Server 2005 running on Windows Server 2003 comes up quite often. So below are some of the features that are depends on the OS and brief description about them. 1. Password policy/expiration check for SQL logins - CREATE LOGIN is a new DDL for creating...
  • Blog Post: Request for topics...

    Please post requests for topics or features that you would like to know about. This can be any of the SQL/TSQL language features or programmability in general. There are so many things to discuss about wrt SQL Server 2005 so it will be good to gauge interest of database developers/DBAs out there. Thanks...
  • Blog Post: Determine primary keys and unique keys for all tables in a database...

    With SQL Server 2005, there are new ways to obtain richer metadata in a database and more efficiently. We have introduced new catalog views that exposes all the metadata that SQL Server uses and can be created by various DDL statements. The older ANSI SQL style INFORMATION_SCHEMA views are also still...
  • Blog Post: Ordering guarantees in SQL Server...

    Ordering guarantees of queries in various context is a common source of confusion. For example, a common workaround to make the results from querying a view ordered is to introduce TOP 100 PERCENT and ORDER BY in the view definition. But this however does not guarantee order in the actual results sent...
Page 1 of 1 (8 items)