Any time you have a database you have a log file. It's an essential part of the database. That said, witness doesn't need any user databases on it.

Need to see the entire query.

Hope that it's a small row set and excellent...

Just join sys.dm_exec_query_stats (as used in the first query) to sys.dm_exec_cached_plans (used in the second query) on the plan_handle

Depends. Do you like your reports accurate or potentially inaccurate. If the latter, nolock's...

Sean Pearce (6/12/2013)

---

GilaMonster (6/12/2013)

---

Sean Pearce (6/12/2013)

---

I prefer Paul Randal's method:

1. Create new filegroup.

2. Create new file on new filegroup. Set this to your required size.

3. Rebuild all indexes with the...

You put the SET before the declaration of the CTE and properly terminate it with a ';'

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;

Oh, and http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx

It probably would be a good idea.

Apparently there are some known bugs that cause this (error 605 with no 824). I was told to search google.

Was the database created in SQL 2005/2008?

If you check the page (via DBCC Page), what's the value for the m_flagBits setting?

Do you have page verify set to CheckSum?

Steven Willis (6/12/2013)

---

But I can add an artificial filter like 'WHERE primarykey > 0" and that seems to force the compiler into doing an Index Seek on that key. I've...

Sean Pearce (6/12/2013)

---

I prefer Paul Randal's method:

1. Create new filegroup.

2. Create new file on new filegroup. Set this to your required size.

3. Rebuild all indexes with the new filegroup as...

It's not a good idea.

The...