+1

John, Could you post the actual execution plans resulting from the 3 major conditions types listed in the article? @pCondition = 1-7,9 @pCondition =8 and @pCondition = 10. ...

ebaya (11/1/2010)

david.avraamides (11/1/2010)

I would consider using a sentinel date such as the maximum T-SQL datetime (9999-12-31) for two reasons: 1) your queries become simpler since you don't always need that...

similarly to find all events that overlapped with a period of time, you might go:

select blah

from events ev

where ev.start_date_time <= '20100701'

and (ev.end_date_time > '20100101' or...

While I agree with some of the initial arguments in the article, particular those around familiarizing oneself with Set logic, boolean Algebra, Etc. I strongly disagree with the approach...

Good article.

This is one of the most common culprits I have found of long running procedures and lock issues at a number of various clients for whom I...

Excellent series of articles. sums up a LOT of what I have seen and been yelling at people for years over...

As I've mentioned on other posts that discuss server side paging, most of the examples I have seen deal with Single Table paging examples.

In most cases that I...

Numerous people have noted that the "holy grail" pattern does not work when there are duplicate values in the sort column.

a simple work around for this is:

With CTE as (

select...

declare @StartDate datetime

Declare @NumBusinessDays int

set @StartDate = '2007-12-25'

set @NumBusinessDays = 50

with Tally as (

select x.num + y.Num as num

from (

select...

Is there really any difference or advantage between Temp Tables and Table variables? If there is not enough cache on hand and both will eventually hit TempDB - is...