SQL Garbage Collector

One of the most important concepts pertaining to any DBMS that every database programmer must know is the Transaction Isolation Levels . Som...

This post is about achieving pagination using stored procedure, without using dynamic SQL. The solution presented should work for both SQL S...

Thinking in sets: The thought process that goes into set- based programming is slightly different from writing procedural code. Say, I ha...

I don't really know why I am starting this series, if it will be really useful for anyone and whether I will be able to keep it running ...

This post is an attempt to explain what parameter sniffing is all about and how it affects the performance of a stored procedure. I would be...

I had already blogged on how we can split a comma separated list using CTEs in my other post on Interesting queries using recursive Common T...

This was actually a question that popped in the discussion forum. I just want to keep all the good things that come out on the discussion fo...

I would like to add a note before you go ahead and read this article. Please do not take this as an approach guaranteed to work. I have come...

Before I start, please do not use these procs in your production code since they are undocumented, which means Microsoft does not support th...

For those who didn't know, the following function definition will throw an error in SQL Server 2000. create function fn1() returns da...

Many a times, we get a question as to get all the days or sundays or weeks between two given dates and join it with someother table and get ...

The scenario I am trying to discuss is to have a table which gives the running total of the values when you select from it. What I am not di...

This requirement was actually a question in the discussion forum. I thought I will keep a copy of my solution here for reference. Okay, so...

Using a NOT operator, be it NOT IN or NOT EXISTS had been a performance bottleneck in most of the queries. No knowledgeable SQL prgrammer ...

There are lots of queries on date operations like getting the first day of the month or week or quarter, last day given some date. So I thou...

There are quite a few number of ways by which we can delete the duplicate records from a table. I am just discussing 3 methods which I find ...

Most of the times when we talk about the ANSI join syntax, we say that we use the ON clause for the joining columns and where for filter. Th...

Before you read further: A more detailed and original post of this scenario is in the msdn blog: Achieving Selective Uniqueness in SQL Serve...

Please Note: Before you go through this article, the approach I have given for SQL Server 2000 is unpredicatable and might fail. The only p...

I cannot find a real necessity to do a case sensitive search in the database. And if it was needed the column or the database should have ha...