SQL Server : Part 9 : Filtered Index : A new way for Performance Improvemnt

Filtered index is a new feature introduced in SQL Server 2008. All the indexes that we have discussed till now...

list of the service applications in SharePoint 2010

Hey Friends,
It’s been a long time , I was out of touch with my blogs. But thanks to all for checking...

Restoring databases to a set drive and directory

 
Restoring databases to a set drive and directory
Introduction
Often people say that necessity is the mother of invention. In this case...

DMV-5 : Queries runing are adhoc or proc , single or multi use ?……..sys.dm_exec_cached_plans

sys.dm_exec_cached_plans DMV (Dynamic Management View), described by BOL as follows : http://msdn.microsoft.com/en-us/library/ms187404.aspx
Returns a row for each query plan that is cached...

Procedural Justice In Database Administration

 
According to Wiki, Procedural Justice (PJ) means:
Procedural justice is the idea of fairness in the processes that resolves disputes and...

Procedural Justice In Database Administration

 
According to Wiki, Procedural Justice (PJ) means:
Procedural justice is the idea of fairness in the processes that resolves disputes and...

Dedicated Admin Connections (DAC) and SQL SERVER 2012 SSMS

TweetG’day,
As part of any SQL SERVER install that I do, I turn on Remote admin connections (using sp_configure) and open...

Amazing SQL Saturday #197 in Omaha

Today I had the privilege of working with a great bunch of folks to help coordinate and host Omaha’s second...

SQL Saturday 203 Boston, Deck and Demos Live!

Hello Dear Reader!

A quick note I'm presenting today at 1:30 pm for SQL Saturday Boston #203.

I'll be giving my...

Multiple ALTER DATABASE SET options

TweetG’day,
Did you know that you can actually combine multiple SET operations into a single ALTER DATABASE statement.
It’s true, you can!
Mostly...