Machine getting frequently rebooted?

Depends. 🙂 If there are duplicate stats (between the dta and...

RESOURCE_MEMPHYSICAL_LOW indicates external memory pressure, the OS is short of memory.

The counters you mention indicate that there is no internal memory pressure, that SQL has enough memory.

How much memory on...

There's a default dependant on the column. Drop that first.

Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Yeah, I got that. In that case make sure that...

NTesla (11/29/2012)

These results were obtained running the command right from a query window.

I do have a scheduled maintenance plan (runs...

There's a reason people have been referring you to Kalen's internals book on a regular basis....

http://sqlskills.com/blogs/paul/post/Inside-the-Storage-Engine-Anatomy-of-a-page.aspx

Are you doing index rebuilds right after the consistency checks?

A page is just an 8kb chunk of data. Given that, what exactly is the difference between a page (an 8kb chunk of data) and the contents of the page...

And the difference between those two is....???

Distinct is not a function. It does not take parameters. It does not give you distinct of a column that you put brackets around. It gets you distinct rows.

For better...

sysindexes is indeed deprecated. It's already been replaced with sys.indexes (7...

No, it won't be the OS drive if the database files aren't on it.

Errors please.

And what...