Part 3: Creating the SSC Maintenance Plan

Note: This is an in-depth article that exceeds 5,000 words, and provides a case-study of how a maintenance plan could...

PayPeriod Matching

Recently I was asked to alter a report to pull different more meaningful data.  The particular report was pulling data...

SQL Server 2008 R2 - official date

Since the August 2009 when the CTP ( Community Technology Preview) version was available, the Microsoft announced the offical release date...

Setting a Dedicated Login To Run DMV Queries in SQL Server 2005\2008

In order to run server scoped DMV queries, you must have VIEW SERVER STATE permission for the login you are...

SQL Server Resource Governor

I didn’t know this bit Resource Governor in SQL Server 2008 is only available in Enterprise edition
 

DDL Triggers

We had a request from a developer who wanted to access data from a source database and another database on...

What Would You Like to See in a New Book on Indexing?

I am currently in the early stages of writing an outline for a new book on indexing, targeted towards novice...

Can query performance be dependent on the client?

This question sounds really easy! The query performance depends essentially on the execution plan, which in its turn isn’t dependent...

SQL Server 2008 R2 - Release May2010

SQL Server 2008 R2 now has a release date...May 2010.

Check out the microsoft site for more details...link to follow

Please Take the Time to Donate for Haiti

This morning, Haiti was shaken yet again by another aftershock of the recent devastating earthquake.  
 
The situation has become so dire...