I say the best way to handle this is to use dynamic sql to construct queries that have explicit values coded for those variables and more importantly allow you to...

dbcc checkdb is one of MANY things that started using tempdb in SQL 2005. You REALLY need a good tempdb on SQL systems.

I think Perry has the best recommendation here - snapshots on the mirrored databases.

Given that you have massive volumes of data to work with and yet are asking basic questions I really must encourage you to get a professional to help you with...

BrainDonor (1/27/2011)

---

Ah, abuse. Completely unhelpful, pointless and altogether disappointing Celko. I have several excellent articles written by your good self that I still refer every now and again, but this...

1) In my experience 'search' type stored procedures are often best done as dynamic sql. Non-trivial to construct but WAAAAYYYYYYY more efficient. Beware SQL Injection if you go...

The BEST way to manage LINKED SERVERS is to never use them at all! They do LOTS of unfortunate things. The way to avoid them is to put...

It is usually best to let sql server handle using space. Why would you want to 'reclaim' unused space? Isn't it likely to just get requested by the...

shifty1981 (1/26/2011)

---

TheSQLGuru (1/26/2011)

---

shaun.stuart (1/26/2011)

---

You generally don't want any database files on the same drive as the OS because database files can grow. If something goes wacky, they could grow to...

Just gotta love the things you can do with a Numbers table!

LutzM (1/26/2011)

---

It looks like you posted the estimated execution plan.

Would it be possible to post the actual execution plan?

Also, would you please post the actual execution of a query that...

shaun.stuart (1/26/2011)

---

You generally don't want any database files on the same drive as the OS because database files can grow. If something goes wacky, they could grow to consume all...

Assuming there is an index on street and cityzip fields on c, it would seem that an index seek and bookmark lookup would be the "really fast" plan. You...

ahh. I took "...manipution have done in sql..." to mean DML only. 🙂

BTW, I consider $1500 (list) VERY inexpensive when it comes to being able to find/unwind "holy...

1) perhaps you can use a plan guide to force a particular plan (i.e. the one that runs fast OUTSIDE of SSIS). the key is the sort - that...