Interests: SQL Server!

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

by VishalGajjar

SQL and Me

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

2011-08-25

731 reads

SQL Server – sp_help without arguments.

by VishalGajjar

SQL and Me

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

2011-08-24

2,485 reads

SQL Server – Hide an Instance of SQL Server

by VishalGajjar

SQL and Me

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

2011-08-23

2,080 reads

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

by VishalGajjar

SQL and Me

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

2011-08-22

1,355 reads

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

by VishalGajjar

SQL and Me

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

2011-08-19

1,042 reads

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

by VishalGajjar

SQL and Me

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

2011-08-18

656 reads

All authors

Blogs

AI Step 1

By Vinay Thakur

As this is an Artificial Intelligence (AI) World, things are changing. We can see that...

A New Word: Nachlophobia

By Steve Jones

nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...

Read the latest Blogs

Forums

Migrating database with many orphan users.

By JasonO

I am currently upgrading a very old database running SQL Server 2008 to SQL...

Active and Active Cluster

By shiv-356842

Hi Team, I am planning to apply security updates for SQL Server 2016 on...

Visit the forum

Question of the Day

What is returned from this query?

SELECT ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh WHERE soh.OrderDate >= '01/01/2011' AND soh.OrderDate < '01/01/2012') AS OrdersIn2011 , ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh WHERE soh.OrderDate >= '01/01/2012' AND soh.OrderDate < '01/01/2013') AS OrdersIn2012 , ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh WHERE soh.OrderDate >= '01/01/2013' AND soh.OrderDate < '01/01/2014') AS OrdersIn2013;

See possible answers