Don't forget the "one true index." All we need is a single, perfect, clustered index that will be all things to all people for all queries for all time. Any...

Nice! I like it.

hunchback (8/21/2013)

---

Try adding OPTION (RECOMPILE) to the second query or use sp_executesql with parameters to do the comparison.

SQL Server uses different approach to estimate cardinality when you use parameters or...

GilaMonster (8/20/2013)

---

Grant Fritchey (8/20/2013)

---

GilaMonster (8/20/2013)

---

No, the same thing, same...

GilaMonster (8/20/2013)

---

No, the same thing, same behaviour, same mechanics.

The...

GilaMonster (8/20/2013)

---

Grant Fritchey (8/20/2013)

---

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...

HanShi (8/20/2013)

---

Grant Fritchey (8/20/2013)

---

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...

First question, always, slow as compared to what? You need to understand where to focus your efforts.

Assuming, as Jeff points out, we have indications of a database problem, then move...

A backup is a page by page copy of the database. A restore is therefore also a page by page copy of the database. There is no way to modify...

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...