Year: 2008

SQL Server 2008 – Filtered Indexes

SQL Server 2008 introduces a new feature called Filtered Index. A filtered index is a way of adding a WHERE clause to the index definition to get faster access to a subset of the data. For instance if you have

Tagged with:

SQL Server 2008 – Backup Compression

The biggest benefit that I see with the new backup compression in SQL Server 2008 is that it improves the speed of the restore. The thing that is far more important that a database backup is the actual restore process,

SQL Server 2008 – Sparse Columns

In SQL Server, an empty or a null column still would take up space in the database, so even if you added a column that was set to null values, there would still be space taken up in the database.

Tagged with:

SQL Server Performance Tuning for the Bellingham .NET users group

Tonight I had the opportunity to present to the Bellingham .NET users group.  About 30 people showed up for the presentation.   SQL Server Performance Tuning and Advanced Query Tuning: This presentation will include SQL Server performance tuning tips and

Tagged with:

varchar(max) and varbinary(max) Questions and Answers

The following applies to SQL Server 2008. How big of an allocation does max represent in the case of varchar(max) and varbinary(max)? Up to 2 ^ 31 – 1 bytes or just about 2gb.   Can I specify a varchar(9000)

Tagged with: ,

More database performance tuning.

Cleaning up extra indexes, and implementing parameterized queries. I don’t know how many times I have had to explain the difference between a clustered index and a non-clustered index.  In the end it is all good. Better performance, faster software,

Query SQL Server 2008 Total Memory Usage

The quick and easy way to determine how much memory your SQL Server is using is to look at the Task Manager on the server and find “sqlservr.exe” in the process list, and look at the “Mem Usage” column. But

Tagged with: , , , , , ,

How much Procedure Cache memory does one SQL Statement take up?

I recently have had the opportunity to work on performance tuning on Microsoft SQL Server 2005. Recently I have been doing more with performance tuning on Oracle. The following is something that I have discovered to be very similar between

Tagged with: , , , ,

Database Tuning at Emergency Reporting

This week I started working at Emergency Reporting doing database performance tuning and scalability work. Currently this is a half time gig focused on SQL Server database performance.  Fun stuff.

Tagged with:

SQL Server 2008 compatibility levels

SQL Server can run in a number of different compatibility levels, but how do you change it and how do you set it. These compatibility levels reflect the version of SQL server. 60 = SQL Server 6.0 65 = SQL

Tagged with: ,