5563

Goat

yuvipoy (3/5/2014)

---

Hi EricEyster,

After having bacth operation is delete operation faster?

how much time you gained after rewritting your query.

Incase what if in lower version of sql server say sql server 2000...

creep

the prevailing wisdom is to use a separate service account for each server with the minimum permissions required to run the service.

Does it need to be part of a SSIS package? If not, you can locate records with grouping:

select Key2

,min(key1) as RecordToKeep,

,count(key1) as RecordCount

from table

group by...

george sibbald (3/5/2014)

---

Stewart "Arturius" Campbell (3/5/2014)

---

Alternatively, change the recovery model to bulk logged just before the load and back on completion thereof.

however, this will require a full backup before and...

We have this scenario and fixed it by creating a Staging database in simple mode next to the DW. fast loads into staging require minimal logging. staging is backed up...

yuvipoy,

we have similar requirements for our real-time systems. We need to delete millions of rows and not cause locking that would stop transactions. I wrote a delete loop that works...

I do not have my script handy at this second, but I know what it does in general.

Create a table with several INT, CHAR, and DateTime columns

use loop operator to...

Awesome. Glad I could help and thanks for marking it as solved.

Megahertz

Tritoch (3/3/2014)

---

I would much rather take a small amount of periodic planned downtime to patch than have a...

RonKyle (3/3/2014)

---

Would you mind explaining further what you mean by this? It's possible that I'm not understanding something,...

Lempster (3/3/2014)

---

Jeff Moden (2/28/2014)

---

Put an index on the "Current-Flag" and watch your GUI's timeout when they try to do an INSERT because of the massive extent splits that will occur....