Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: August 2011

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 post to get highlights of what has been updated.

 

Download Links :

SQL Server 2008 SP3 CTP : http://go.microsoft.com/fwlink/?LinkId=226850

SQL Server 2008 SP3 Express CTP : http://go.microsoft.com/fwlink/?LinkId=226851

 

SQL… Read more

0 comments, 362 reads

Posted in SQL and Me on 25 August 2011

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 summary information for objects of all types in the database. These includes all user tables, system tables, stored procedures, functions, extended stored procedure, Assembly Stored Procedures, etc…

  Read more

0 comments, 802 reads

Posted in SQL and Me on 24 August 2011

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 to Server" dialog box in Management Studio:

As you can see from the screen shot, all of my instances are visible on the network. If I… Read more

0 comments, 693 reads

Posted in SQL and Me on 23 August 2011

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 CDC

These features are available only on Enterprise/Developer editions of SQL Server. You cannot attach or restore databases utilizing these features to a "lower" edition, such as…

Read more

0 comments, 609 reads

Posted in SQL and Me on 22 August 2011

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 0 and 1, both inclusive.

Computation formula used by PERCENT_RANK():

     (RANK() – 1) / (Number of Rows – 1)

     where, RANK() is the rank of the row within… Read more

0 comments, 477 reads

Posted in SQL and Me on 19 August 2011

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 and <= 1, which represents percentage of number of rows with value less than (for ascending order) or equal to current row.

For example, consider below data:

Year Read more

0 comments, 282 reads

Posted in SQL and Me on 18 August 2011