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 » General » SQL Server 2005   (RSS)
Sorry, but there are no more tags available to filter with.
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) Read More...

Posted Friday, July 14, 2006 4:25 PM by SQL Server Engine Team | 10 Comments

Filed under: ,

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 Read More...

Posted Monday, October 10, 2005 11:34 AM by SQL Server Engine Team | 0 Comments

Filed under: ,

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 Read More...

Posted Thursday, October 06, 2005 6:34 PM by SQL Server Engine Team | 10 Comments

Filed under: ,

Page view tracker