The query given in "Detecting Heaps" will also list tables that have indexes, for example non-clustered PK.

I really didn't see the date "TenCenturies" posted 🙁

But, could help the future visitors though.

Did you try reducing the max server memory on the SQL Server intance, leaving more memory to the OS?

This solved in one of my instances.

One way to reproduce this wait type is documented here:

http://www.quicktechnotes.com/2014/12/25/wait-type-preemptive_os_getprocaddress/

A possible solution is with SP3.

http://www.quicktechnotes.com/2014/11/15/session-reset-for-connection-pooling-and-sp3/

No, SP2 followed by any CU does not seem to help resolve this issue. With this version "Microsoft SQL Server 2008 R2 (SP2) - 10.50.4286.0 (X64) May 29...

Dropping of global temp table can be tested this way too:

Create the global temp table in a query window.

Close it.

Open another query window and try to access it.

Excellent article !

As I said before, the script in questions works fine in 2000 and 2005 as well.

Without the INSERT, if you only SELECT it doesn't. The SELECT with different datatypes, does...

I tried in SQL 2005. It worked fine.

While inserting, it perform implicit conversion of numerals into varchar.

But if SELECTed, it does not convert it.

I want to add that your code is fail-safe and always runs without error, irrespective of the source table structure changes.

To achieve this, you may go for DBCC DBREINDEX.

Please try this command on the target table.

It is faster and more efficient since you are running for several databases.

For the scheduling, you can make use Job Scheduler under SQL Server Agent available in SQL Server. Did yoy think about the server resources ?

Books-online

DBCC CHECKDB is...