How SQL Server Index Statistics works - Part 2

This article demonstrates the real world examples of how SQL Server utilizes the index statistics.

Posted Under: Caching, Information, Performance, SQL Server 2005, Tuning
This post was written by namwar on July 31, 2008 Comments (0)

How SQL Server Index Statistics works - Part 1

This article describes the concept of index statistics in SQL Server and how it is used in query optimization.

Posted Under: Information, Performance, SQL Server 2005, Tuning
This post was written by namwar on July 17, 2008 Comments (2)

SQL Server and Windows 2008 Server Core Installation

Microsoft has introduced an option in Windows 2008 installation which is called Server Core. This option allows you to install a smallest possible footprint of Operating System for a specific role to be performed by the server like File Server, Domain Controller etc. This installation does not have usual graphical interface of OS like Windows [...]

Posted Under: Information, Performance, SQL Server 2008, Windows 2008
This post was written by namwar on April 27, 2008 Comments (3)

Cache Efficient Dynamic SQL Queries and how Query Plan Caching works in SQL Server

This article describes how sql server query plan caching works. It gives you working examples of how to write cache efficient dynamic sql queries.

Posted Under: Caching, How-To, Information, Performance, TSQL, Tips, Tuning
This post was written by namwar on February 10, 2008 Comments (1)