dbcc useroptions

yeah... and all stored procedures that touch it 😀 😀

Steve, I know he did. I was just making sure it was not by chance 😉

select db_name(dbid)

Cheers,

jason (9/28/2007)

---

I administer an environment that consists of databases that are rolled forward quarterly (going back 5 years). Only the current quarter is actively being modified. Each "archive" database...

We are all asumming you are using sql server 2000, right ?

B U G S

:hehe:

totally agree with Colin, in those heavy OLTP system the dough is on the IO subsystem 😀

From Experience I know Lumingent is BIG $$$ but I am not sure it captures "reads" though.

DBASkippack (9/28/2007)

---

Noel - thx for the feedback. Just wanted to make sure I read this correctly.

(Are you sure Microsoft didn't do this to catch up w/ DB2...

jonas.jillerholm (9/27/2007)

---

Thanks all for the quick response. Now to some answering of questions, unfortunatly there will be plenty rows left in table after delete :doze: and there are foreign keys...

Yes Whe you review the "table" the number is in MICROSECONDS and you must divide by 1000000 (one million) Profiler UI is being nice to you and showing it in...

In 2005 you can use the TOP clause to avoid the use of "SET ROWCOUNT"

WHILE 1=1

BEGIN

DELETE...

Yes it does! If you are not using "multiple" partitions it...

There is IMHO nothing like eating your own dog food to prove your clients how much you trust the product you sell. I know that not all cases are in...