The WAITFOR wait type indicates that the session in question is currently running a WAITFOR DELAY or WAITFOR TIME statement.

http://msdn.microsoft.com/en-us/library/ms187331.aspx

Lansend1 (7/2/2014)

---

Thanks Gail will check the book out.

Luis Thanks for the response, please see below for output of query, but note we did not set it , the server...

No, you don't.

Sliding window, fast deletes (of entire partition of data), index rebuilds at the partition level.

Partitioning's not usually about performance in the first place.

Cursors? Why?

SELECT MAX(ABS(t.idvalue - maxID.idvalue))

FROM #temp AS t

CROSS JOIN (SELECT TOP (1)

...

TheSQLGuru (7/2/2014)

---

High Power setting, numerous associated with the IO subsystem (regardless of type). Many/most SQL Servers are or are now being put on VMs and there are quite a...

To be honest, most things I would leave at default unless I have a good reason...

Please take a read through this: http://www.sqlservercentral.com/articles/Administration/64582/

Jeff, would you mind removing the quote of the spam post (that's all those are)?

No, it doesn't. It is not a count of...

DO NOT check boost priority. It should not be enabled and can lead to OS instability if it is enabled.

Max server memory should be set. See chapter 4 of https://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/...

Does that directory exist?

Scan count != number of table scans. Rather ignore the scan count, it's not consistent.

No.

Nolock is not a performance tuning technique....

Backups. First and most important, get your backups set up and ensure that your backup strategy can meet your SLAs

Integrity checks. Often enough that should you encounter corruption restoring from...