SQL Server – CTP is now available for SQL Server 2008 Service Pack 3

CTP has been made available earlier this week for SQL Server 2008 SP3 on Download Center. Read this MSDN blog...

SQL Server – sp_help without arguments.

sp_help returns information about database objects and types.
@object_name argument is optional for sp_help. When executed without any argument it returns...

SQL Server – Hide an Instance of SQL Server

You can browse available SQL Instances on network by choosing "<Browse for More..>" from Server Name drop-down list in "Connect...

SQL Server – sys.dm_db_persisted_sku_features tells you about edition-specific features

sys.dm_db_persisted_sku_features lists all features which are utilized by the database. Features specific to Enterprise/Developer edition are:

- Compression,
- Partitioning,
- TDE and...

SQL Server – "Denali" – PERCENT_RANK() Analytic Function

PERCENT_RANK() returns the position of a row within the result set. In contrast to RANK() function, PERCENT_RANK() ranks rows between...

SQL Server – "Denali" – Using Analytic Function CUME_DIST()

CUME_DIST() calculates relative position of a value relative to a group of values. The value returned by CUME_DIST() is > 0...