The optimal index for the query given is:

CREATE INDEX [IX dbo.CoverageVersions CoverageKey,Effective (SourceKey,CovRefundKey,TypeKey,StatusKey)]

ON dbo.CoverageVersions (CoverageKey DESC, Effective DESC)

INCLUDE (SourceKey, CovRefundKey, TypeKey, StatusKey)

WITH ...

Brandie Tarvin (12/13/2010)

---

Okay, it must be too early in the morning because I'm getting different execution plan results this morning that I know I got last week. For one, I...

Help us to help you:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Existing SSC articles that you may find helpful:

http://www.sqlservercentral.com/search/?q=hierarchy&t=a

jteeter (12/21/2010)

---

I solved this with a brute-force and fairly ugly approach. I'm certain there's some elegant way to do it, but it escapes me. Here's what I did...

How can you be sure? My copy of Books Online says sys.syscolumns is a...

So, my advice is:

1. Remain in 80 compatibility only as long as it takes you to update your code to be fully compatible with 2005.

2. Start using new...

KMPSSS (12/22/2010)

---

I have small doubt in this,

Right now sql compatibility level is 80.

But in this cross apply and CTE type are accepted. only the problem is pivot type.

...

You're right that there are no simple answers that are always applicable, but there are some guidelines.

First, using EXCEPT is almost never going to be the best way to accomplish...

Short answer: you can't, so you're going to have to make some changes.

Replace all the uses of *= and =* with the new syntax. No-one uses *= and =*...

Gianluca Sartori (12/22/2010)

---

Well, indeed my post was a bit abrupt...I have to admit I am a bit biased: some weeks ago I had to rewrite a lot of queries that...

Another natural option is the recursive one:

DECLARE @Example

TABLE (

ID INTEGER PRIMARY KEY,

...

Gianluca Sartori (12/21/2010)

---

... if you like Nested Loops! 😛

It's a great feature, but it often ends up with a Nested Loops...

Revenant (12/21/2010)

---

It is wider than that. As I mentioned above, if you are a pro,for 64 bits you better develop under 64 bits. That means upgrades to dev workstations...

Jokes very rarely benefit from being explained in detail, but take a look at the...

Mr Magoo was joking: in SQL Server timestamp is a mechanism for version-stamping rows. It...