Another option for testing, but only for testing read operations, is to export the statistics from the production database and then import them into your test database. The query optimizer...

Not that Jeff's answer needs reinforcement, it sure can't hurt to repeat the fact that backing up to a local drive through some automated process (I assuming you're automating your...

But, by snapshotting to a seperate set of disks and then performing DBCC there, you won't be seeing the physical layout checks run against the original set of disks. If...

I'd suggest first understanding why you're experiencing the blocking. You can use sys.dm_exec_query_stats to see what is being blocked. Resolving the issues at the query or index/structure level is the...

below86 (8/16/2013)

---

Thanks for the info, I'll have to look into 'cool' ways I can use this. I know it's just a simple example but I can't see how I...

calvo (8/16/2013)

---

A Common Table Expression is a temp table with the scope of a single DML statement. There's all kinds of cool ways to use them but the basic syntax...

Paul White (8/15/2013)

---

Jeff Moden (8/15/2013)

---

While I've found some workarounds for it, it seems bloody incredible to me that you cannot rebuild a partitioned index at the partition level in an...

Everything Gail said.

But, if you do have a problem with a plan in cache (again, nothing to do with tempdb), then it is possible to run DBCC FREEPROCCACHE and pass...

Shortest possible answer, do your best.

There is no easy way to deal with people who are unreasonable. But, work your communication skills. Develop a tough skin. Do what you can....

This is a classic, it depends problem. Depending on how you structure the indexes and how your data is being loaded, yes, clustered indexes actually speed up insert operations. But,...

Or, if it's not causing any problems, don't fix it. I wouldn't recommend someone to automatically rebuild 1000+ indexes every week. Instead, I'd probably have a script that only rebuilds...

Nothing really. The secondary will be somewhat slower for I/O. If you have synchronous calls that might cause some problems. Async calls will work the way they're intended. In general,...

One way to do it would be to take advantage of PowerShell remoting. You can pull from a list of databases (or generate them) and then run the commands you...

You'd have to define "what it does" better. I can look at the code and quickly get a sense of how it was written. Are there corellated sub-queries in the...

One of those instances where I wish we could vote on answers. SQL Surfer has nailed it. When you're creating that backup in the GUI, just generate the script.