SQLServer

Please vote for my SQLPASS precon and sessions

A few days ago, SQLPASS opened the voting for the precon’s and sessions for the annual SQLPASS community summit. I’ve also submitted 4 sessions and one precon, and I would be very happy if you can vote for them. Here are the 4 session abstracts: Advanced SQL Server 2008 TroubleshootingIt’s Friday, 05:00pm. You are just …

Please vote for my SQLPASS precon and sessions + read more

RCSI/SI doesn’t work with rows larger than 8046 bytes

During this week I have prepared a workshop about Locking & Blocking for one of my customers. One big part of this workshop was also the new Optimistic Concurrency model that SQL Server offers us since the inception of SQL Server 2005. Since SQL Server 2005 we have the READ COMMITTED SNAPSHOT ISOLATION level (RCSI) …

RCSI/SI doesn’t work with rows larger than 8046 bytes + read more

How SQL Server stores indexes on variable length columns

In the last months I had done a lot of performance tuning workshops, and there is almost the same question: How SQL Server stores indexes on variable length columns? Therefore I thought this would be a great topic for a weblog posting. To examine the concrete storage details of an index defined on a variable …

How SQL Server stores indexes on variable length columns + read more

2 of my favorite new T-SQL features in SQL Server Denali (SQL 11)

Microsoft released the first CTP version of SQL Server Denali during the SQLPASS Community Summit in Seattle last year. Since this major event in the SQL Server community I had a little bit of time to look into the CTP 1 version of Denali and see what new features they are providing us. 2 interesting …

2 of my favorite new T-SQL features in SQL Server Denali (SQL 11) + read more

I’m speaking for the Performance Virtual Chapter of PASS

On January 4, I’m speaking about index internals for the Performance Virtual Chapter of PASS (http://performance.sqlpass.org). Here’s my session abstract: SQL Server provides two kinds of indexes for relational data: Clustered- and Non-Clustered Indexes. Both of them can be defined as unique and non-unique. In this session you will learn how to use Clustered- and …

I’m speaking for the Performance Virtual Chapter of PASS + read more