That's a very broad topic. Here are a few of my personal pointers

1) Pick the clustered index first and pick it carefully

2) Keep the clustered index as narrow as practical...

You have 4gb of memory on a production box running both SQL Server 2000 and SQL SErver 2005? I'd be willing to bet you're seeing serious memory pressure and probably...

What made you choose those 12 fields? Were you working from a query plan or missing index information or recommendations from the Tuning Advisor?

You need to look at the execution...

No, I don't think it rearranges the nonclustered indexes.

If you're doing large scale loads, you might want to drop the indexes & recreate them after the load because a large...

Jeff Moden (3/26/2009)

---

Grant Fritchey (3/26/2009)

---

Bob Hovious (3/26/2009)

---

CONGRATULATIONS, ROY !!!!!

YOU are Mr. 3000.

In honor of this momentous occasion, you get to buy beers for...

Alvin Ramard (3/26/2009)

---

Jeff Moden (3/26/2009)

---

Grant Fritchey (3/26/2009)

---

Bob Hovious (3/26/2009)

---

CONGRATULATIONS, ROY !!!!!

YOU are Mr. 3000.

In honor of this momentous occasion, you get to buy...

If you have to ask, we can't tell you.

Actually, you shouldn't be able to see fnord:anything between the:fnord fnords....

Sorry, you ought to be able do something like the following. There are probably better ways, but this...

Luke L (3/26/2009)

---

Chris Morris (3/26/2009)

---

If anybody wants to know...

Quotes are acting all wonky...

Anyway, I sure can have scotch & fly a Star Fury. It's space... what am I going to hit?

Besides, I've operated nuclear power plants while inebriated...

Bob Hovious (3/26/2009)

---

CONGRATULATIONS, ROY !!!!!

YOU are Mr. 3000.

In honor of this momentous occasion, you get to buy beers for the whole gang, and...

Chris has it. You should be able to use the PK value as an ordering clause. Delete the rows where the ID is not equal to the top ID ordered...

How about using the last update date column as a differentiator. Then you can order by that column and join on the text column. I would think that should get...

Not without some structures and execution plans. It's just too hard to guess at what might work in your circumstances.

Actually, it works fine. I just did it. You get the query results and the messages in a single window when you change the output from the default grid to...