How to use more than 4GB RAM on SQL Server?

This article describes the procedure to make sure your SQL Server is able to use more than 4GB of RAM, if installed

Posted Under: How-To, Information, SQL Server 2005, SQL Server 2008, Tuning
This post was written by namwar on January 15, 2009 Comments (1)

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)

Selectivity of a Query and how it affects indexing

If you want to understand how selectivity of Query works then read this article.

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

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)