Sunday, 8 January 2012

Plan Cache and Parameter sniffing in SQL Server 2008

›
I have recently encountered    performance problem with one of my production servers due to parameter sniffing in SQL Server 2008. It actu...
12 comments:
Sunday, 20 November 2011

How to retrieve TOP Distinct values in SQL Server

›
I have recently got a requirement from one of our customers to show recently used distinct items for a particular report. While writing the ...
4 comments:
Sunday, 19 December 2010

How to Create Linked Server between MYSQL and SQL Server

›
Steps to configure Linked Server Step 1: Install the My SQL OBDC connector on the SQL Server machine (This will come default if you have ...
9 comments:
Tuesday, 23 March 2010

How to run a SQL batch multiple times

›
Today I came across one surprising use of GO statement in SQL Server which is solely used as batch terminator in SQL Server utilities such a...
6 comments:
Monday, 22 February 2010

How to recover a Database in suspect mode

›
I was struck with a database which is on suspect mode and need to recover it without any recent backups. I searched across the net and found...
9 comments:
Wednesday, 18 November 2009

Filter Index in SQL Server 2008

›
SQL Server 2008 introduces a new type of index called “Filtered Index” which is basically a covered indexed designed to retrieve a smaller s...
9 comments:
Wednesday, 4 November 2009

How to select records with in Date Range

›
Selecting records within a given date range is one of the common requirement these days, but many people find it difficult. The most common ...
4 comments: