Flo,

The Quirky Update method is a valid approach here, but you cannot use a JOIN!

Also MAXDOP 1 must be specified to avoid parallelism.

Using your example table, I would write the...

hxkresl (7/17/2010)

---

I want to optimize the performance of a large table by partitioning it and storing each partition in a separate filegroup. The database and the table have been...

Ah! That was it - sys.sp_cdc_change_job - I didn't have a CDC instance to hand to test so thanks...

8kb (7/17/2010)

---

I stumbled upon this scenario because of a very large table running in SQL Server Express that was causing an out of memory error during DBCC CHECKDB. The overwhelming...

Stupid question. This post gives me one point back.

Stupid question. This post gives me one point back.

Stupid question. This post gives me one point back.

Tara-1044200 (7/17/2010)

---

OK i have the partitions made based on year and if i delete paritions older than 10 years from it, does it have only that data i need after...

Jim mentioned XML indexes earlier.

My contribution is: full-text indexes.

SELECT name FROM Table1 GROUP BY name;

or, equivalently...

SELECT DISTINCT name FROM Table1;

Well that's just weird. I just posted on one of the 2-year-old threads referenced in this article earlier this morning, before I saw that this article had been republished....

CirquedeSQLeil (7/17/2010)

---

Hence, your...

Isn't...

Steve Jones - Editor (7/17/2010)

---

I am sure they have done some work here, but I wonder if they've done any recently. The work Peter Spiro did on 7, rewriting all...

Steve Jones - Editor (7/17/2010)

---

I did get an email back from the author. He/she said that they just ran out of patience that people weren't understanding his point and posted...