First hit on google for "MEMORYCLERK_SQLBUFFERPOOL single page allocator"

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/2c14df9a-0f82-45a5-ac53-13062eb3a2df/

And the BoL page for the DMV you're using

http://msdn.microsoft.com/en-us/library/ms175019%28v=sql.105%29.aspx

You can look at the execution plan, you're looking for the last arrow, the one pointing at the select operator. It is an estimate, not an actual, assuming stats are...

Move that table to a different database, set that DB to simple recovery. Logging cannot be disabled for an object.

Get more drive space (optimal)

Don't restrict your log file. When it...

It can go straight to the data. The RID is a 8-byte combination of file ID, page number and slot array. The first 2 allow SQL to go straight to...

A large log file does not in and of itself cause perforance problems. If a log file fills and has to grow, it will slow down any data modifications occuring...

Order of columns in a table has no meaning.

can we rebuild...

I assume you mean the log file...

It does get truncated, every time a checkpoint runs. Truncate means make log space reusable, not make log file smaller. The only thing that...

http://ola.hallengren.com/Versions.html

http://sqlfool.com/2011/06/index-defrag-script-v4-1/

Just 2 of the options available.

You also might mention that getting the wrong result fast is usually not acceptable to users. Most users would rather have the correct results, even if it does take slightly...

SET STATISTICS TIME ON.

And send them this http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx

SQL_ME_RICH (11/23/2012)

---

Is there a query that I could run against some of the system objects that would retrieve a time/date stamp for me of when the Isolation Level was...

Do feel free to test it out though

Can you have some patience? It's only been an hour, on a holiday weekend for the US.

If the largest index is 80 GB, then the peak usage of TempDB won't...

Go rebuild all your indexes.

sysdatabases is deprecated, included only for backward compatibility with SQL 2000 and should not be used in new development.

Replacement is sys.databases