I assume you...

WayneS (12/29/2010)

---

Just to point out that this code:

IF EXISTS (SELECT * FROM tempdb..sysobjects WHERE name like '#Customer%')

DROP TABLE #Customer

is NOT the proper way to test for the existence of a...

You meet dead people? :unsure:

mtassin (12/21/2010)

---

These days I begin to wonder if the optimizer doesn't just return them in clustered index order when the ORDER BY clause is omitted (and a clustered index is...

Or, even more succinctly:

WITH Records (Old_Seq, New_Seq)

AS (

...

I think that removing 32bit support from the next version of SQL Server would be a huge technical and marketing mistake, and even long time users would be slower to...

There have been an unusual number of large quakes in the region recently,...

The idea is usually to write a CLR trigger which can be attached to many objects, auditing the same information for...

TheSQLGuru (12/23/2010)

---

Bummer is that the optimal index is essentially another copy of the table, which could be large given that it is a DW fact table and also gum up...

Exciting isn't it!

GilaMonster (12/22/2010)

---

It's funny, most of the posts on my blog are related to performance (execution plans, indexes, T-SQL performance comparisons or concerns). So what's one of the...

Revenant (12/22/2010)

---

We develop for 16-to-32 GB 64 bit Enterprise on 8 GB workstations that are running 64 bit Developer. If you are developing under 32 bits for a 64 bits...

jteeter (12/22/2010)

---

Thanks Peter. I knew a simple solution was out there, I just couldn't visualize it how to pivot it appropriately. As to other tools, for a product...

Gail is the subject of the 10th day of SQL:

http://crysmanson.com/2010/12/22/on-the-10th-day-of-sql/

Definitely counts as elegant in my book. 🙂

As a regular Top-N-Per-Group problem, we can also write it using a ranking function:

SELECT fcvsq.CoverageKey,

fcvsq.SourceKey,

...