Browse by Tags
All Tags »
General (RSS)
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...
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)
Read More...
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.aspx
Read More...
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
Read More...
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
Read More...
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
Read More...
Determine primary keys and unique keys for all tables in a database using INFORMATION_SCHEMA views and the new catalog views in SQL Server 2005
Read More...
Ordering guarantees in queries.
Read More...
