I would look at partitioning the table. Check that out in BOL. It could be a performance saver for you.

Also, you should check the query being used for...

One of the big considerations is licensing. Another consideration is performance. In my current environment we have SSIS, SSAS,SSRS, and SQL Server installed on the same server in...

If there are operations already being performed on those tables at the time you start the rebuild / reorganize, then you will see a delay. Rebuilding and reorganizing also...

Nice article Seth. I will be adding this article to my arsenal.

Best one yet.

I like how it appears that there is a play on the previous one with Derek being the "monitoring agent."

Lynn Pettis (4/6/2010)

---

CirquedeSQLeil (4/6/2010)

---

Nicholas Cain (4/6/2010)

---

Something I've not seen mentioned but really should be kept in mind with this is that cost should really not be a barrier to entry....

Nope - don't see where the close parenthesis belongs 😉

Paul White NZ (4/6/2010)

---

If the deadline was 6^th April, it was missed by 17.5...

BTW, I like the idea driving this script. Nice job.

sumit.joshij (4/6/2010)

---

At least we all of you have to check the ORCALE database, those who are in favor of maintain the FK constrain.

At least they(ORACLE corp) can have the knowledge...

Yes I got it correct.

I thought you explained things...

cvn Rao (4/6/2010)

---

Hi,

Iam getting syntax errors while testing the syntax for the procedure sp_whoio..

Can you please suggest on this ? Iam using sqlserver 2005.. Infact the output of this sp_whoio...

Jeffrey Williams-493691 (4/6/2010)

---

CirquedeSQLeil (4/6/2010)

---

Paul White NZ (4/6/2010)

---

Probably will - though the definition of 'today' varies...;-)

Eight hours of 7^th April 2010 remain...

Paul White NZ (4/6/2010)

---

CirquedeSQLeil (4/6/2010)

---

...Master and Model should not be very big. MSDB might get some weight to it (but still kind of small). I move them personally...

Nice question Paul.