From where? In what fron end?

When, how & why do you want to do this?

I agree there can be significant gains. Imagine a system with only 3 GB available to SQL and wasting 1 GB on that cache (I doubt it's possible but...

This is just a bandaid rather than a full solution... but I remember reading from a trusted source that he dramatically increase the backup speed by backing up to 4...

Backup / restore is a perfect copy. Nothing changes (stats, indexes, data, fragmentation, etc).

This will allow you to only work on the indexes that need to be defragmented /...

L' Eomot Inversé (9/20/2011)

---

GilaMonster (9/20/2011)

---

LutzM (9/20/2011)

---

We just need to be careful: once we're short on apostrophes, quite a few letters (including the "blank") will be in highe demand, too. (It's...

And he's on fire!!

Tell...

mtillman-921105 (9/20/2011)

---

Ahh, basking in the Great CELKO wisdom:

"We use sets, not loops; loop are like eating babies. You might do it once but you do not tell people about it."...

We'ev a had a few bad dba jokes thread flying around.. maybe you need to copy that over there :-D.

SELECT * FROM (SELECT <rank goes here>, * FROM sys.objects) dtRank WHERE dtRank.object_id = 4

tfifield (9/20/2011)

---

Thanks Gail....

mtillman-921105 (9/20/2011)

---

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

---

Doesn't that just...

SQLRNNR (9/20/2011)

---

Evil Kraig F (9/20/2011)

---

Remi, I'd say you need a hobby, but apparently you already had one... Poor Lowell.

What will Lowell ever do with himself now?! Shame on you,...

Evil Kraig F (9/20/2011)

---

Remi, I'd say you need a hobby, but apparently you already had one... Poor Lowell.

What will Lowell ever do with himself now?! Shame on you, Remi....

Any way to shorten the transactions?

Maybe use a local temp table to save the next 4-5 ids to process.

Then in the main table have 1 flag assigned. Do the...