Necromancing the Chicken

First off, I’m sorry this space has been dead for so long. I’m sure I’ve dropped off many an RSS...

SQL Server : Index at a glance

In the last ten posts, we have discussed in details about the SQL server index and its storage structure. In...

SQL Server 2012 Diagnostic Information Queries (April 2013)

Here is the April 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...

SQL Server Management Data Warehouse (MDW) – Why it Rocks

Ensuring excellent performance for users and customers is a high priority for Database Administrators.
Today I want to share a free and easy...

SQL Server Management Data Warehouse (MDW) – Why it Rocks

Ensuring excellent performance for users and customers is a high priority for Database Administrators.

Here I share a free and easy way for you to get valuable insight into the...

The Bucket List – Item #1 is (finally) finished

We all have a bucket list – that list of things that we want to accomplish before one, well, kicks the...

Calculating the length of a string (Len vs DataLength)

This one is basic but still something that can catch you unawares if you aren’t careful. Most DBAs and developers...

Customizing SSMS–Results

This is a short series on some customizations in SSMS to make it visually more appealing.
As a presenter, I’ve learned...

Determining when statistics were last updated in SQL Server?

I received an email from friend today asking how he can see when statistics were last updated in SQL Server....

DMV-7 : Find Queries waiting for memory ?……..sys.dm_exec_query_memory_grants

sys.dm_exec_query_memory_grants DMV (Dynamic Management View), described by BOL as follows : http://msdn.microsoft.com/en-IN/library/ms365393.aspx
Returns information about the queries that have acquired a memory...