When did the Spell Check feature appear? I like it.

peter-757102 (5/13/2011)

---

One other idea I have been playing with but found no query hints for, was to see the effect of parallelization. Currently the cost estimates for each step in...

Or...

SELECT

TTV.Department,

TTV.Receipt,

TTV.StartDate,

TTV.EndDate,

DV.HoursActive

FROM @TestTV AS TTV

JOIN

(

SELECT DISTINCT

...

Ninja's_RGR'us (5/9/2011)

---

Just to pile on more proof...

Run this and look at the xml plan generated :

SELECT COUNT(*) FROM sys.columns

UNION ALL

SELECT COUNT(1) FROM sys.columns

UNION ALL

SELECT COUNT('Whatever string') FROM sys.columns

The plan...

Here's an interesting exception: SELECT *...

GilaMonster (5/9/2011)

---

Count(*) is the fastest of the count() forms. It can not be slower than Count(column name) which has to additionally check to see if the column is null or...

The T-SQL equivalent uses FOR XML PATH:

DECLARE @data TABLE

(

group_id INTEGER NOT NULL,

data ...

In theory, yes; but it's almost certainly not worth it. Without going into too many...

About the little wiggly bits at the start of the green lines (the SQL CLR implementation): CLR code is compiled to an intermediate language to make it portable across different...

How to Implement an Automatic Sliding Window in a Partitioned Table on SQL Server 2005

The search engine I tried came up with several pages of links, several from MSDN or Books Online. For...

My numbers (or 'tally') table has a different name from yours, but the following code illustrates another way to write this query. I wasn't sure if you wanted to...

WayneS (5/6/2011)

---

I know what you mean. I, for one, am looking forward to the revealing of the ultimate DelimitedSplit function. It...

Well done, Brandie.

+1