DBCC shows Msg 2593: There are ROWCOUNT rows in PAGECOUNT pages for object. It is harmless and for information only. Here is what it means.
SQL SERVER – Index Reorganize or Index Rebuild
When should you use Index Reorganize and when Index Rebuild? I get this question a lot, so here is a pointer to my earlier post that explains both with T-SQL.
SQL SERVER – Introduction to Performance Monitor – How to Use Perfmon
How to use Perfmon: three ways to start Performance Monitor, how to add counters, and how to log them over time so you can compare later.
SQL SERVER – Introduction to Three Important Performance Counters
Three basic but very important Performance Counters: % Processor Time, Avg. Disk Queue Length and Disk Read and Write Bytes/sec, and what their values mean.
SQL SERVER – Get Current Database Name
Need the current database name in a script? SELECT DB_NAME() returns the name of the database you are running the query in. It is a one line answer.
SQL SERVER – 2005 – Find Unused Indexes of Current Database
A simple but accurate SQL Server 2005 script to find unused indexes in the current database, since unused indexes slow down INSERT and UPDATE statements.
SQLAuthority News – RIP: Ken Henderson, 1967 – 2008
RIP Ken Henderson, 1967 to 2008, author of the SQL Server Guru’s Guide books and the author I respected the most. A few words in his memory.