Browse by Tags
All Tags »
SQL Server 2005 (RSS)
Converting hexadecimal values to varbinary and vice versa is now easier using the XQuery functionality available from SQL Server 2005. The code samples below show how to perform the conversion(s): -- Convert hexstring value in a variable to varbinary:
Read More...
Converting Base64 values to varbinary and vice versa is now easier using the XQuery functionality available from SQL Server 2005 onwards. The code samples below show how to perform the conversion: -- Convert Base64 value in a variable to varbinary: declare
Read More...
The SQL Server 2005 Performance Dashboard Reports are Reporting Services report files designed to be used with the Custom Reports feature introduced in the SQL Server 2005 SP2 release of SQL Server Management Studio. The reports allow a database administrator
Read More...
SQL Server 2005 SP2 has an important enhancement to OBJECT_NAME metadata function and a new OBJECT_SCHEMA_NAME metadata function. I will first describe the old functionality to give some context and demonstrate how the new features help a lot. Please
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...
I saw an interesting question today in the MSDN Transact-SQL forum about implementing PERCENTILE_CONT analytic function that is available in Oracle in SQL Server. The function description as noted in the Oracle docs is below: The PERCENTILE_CONT function
Read More...
Attachment(s): Oracle PERCENT_CONT Implementation.sql
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...
Top N costly query plans
Read More...
Determing optimal MAXDOP setting value using DMV
Read More...
Renaming sa account in SQL Server 2005
Read More...
SQLCLR TVF to read registry settings for SQL Server instance
Read More...
Database Mirroring configuration using certificate authenticated endpoints.
Read More...
Queries to get direct dependencies on the column.
Read More...
Using OUTPUT clause in INSERT/UPDATE/DELETE statements
Read More...
