Questions and Answers Website.
Tonight I created the Questions and Answers website. My wife was watching Mamma Mia (the movie), and that lost my interest quickly so I went… Read More »Questions and Answers Website.
SteveStedman
On to a new adventure – Teaching SQL Server
I have just finished all of the paperwork. For spring quarter 2009, I will be teaching a SQL Server DBA class at Western Washington University.… Read More »On to a new adventure – Teaching SQL Server
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… Read More »SQL Server 2008 – Filtered Indexes
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… Read More »SQL Server 2008 – Backup Compression
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… Read More »SQL Server 2008 – Sparse Columns
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… Read More »SQL Server Performance Tuning for the Bellingham .NET users group
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… Read More »varchar(max) and varbinary(max) Questions and Answers
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… Read More »More database performance tuning.
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… Read More »Query SQL Server 2008 Total Memory Usage
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… Read More »How much Procedure Cache memory does one SQL Statement take up?