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.
Reading Memory Clerks to See Where Memory Goes
Memory clerks show how SQL Server allocates memory among engine components; learn to read the DMV, spot unusual growth, and investigate safely.
SQL SERVER – Microsoft SQL Server Compact 3.5 SP1 Beta for ADO.Net Entity Framework Beta 3
SQL Server Compact 3.5 SP1 Beta for the ADO.Net Entity Framework Beta 3 lets applications work with a conceptual model instead of a fixed storage schema.
SQL SERVER – Sharpen Your Basic SQL Server Skills – Database backup demystified
Database backup demystified was my article in the January 2007 edition of SQL Server Magazine, written to sharpen your basic SQL Server skills.
SQL SERVER – Import CSV File Into SQL Server Using Bulk Insert – Load Comma Delimited File Into SQL Server
How to import CSV file data into SQL Server with BULK INSERT: create a table, point to the comma delimited file and load every row in a few quick steps.
SQLAuthority News – SQL Joke, SQL Humor, SQL Laugh – Funny Microsoft Quotes
I have received many emails that I should write more post like SQLAuthority News – SQL Joke, SQL Humor, SQL Laugh – Funny Quotes.