Contact Us

Traditionally, we want our Clustered Index to have the following attributes: Narrow: So that our clustered index and the non-clustered indexes that point to it will be as slim as possible Static: So that we don’t generate fragmentation in the clustered index and we don’t have to update the non-clustered indexes Ever-increasing: So that we don’t generate a lot of page splits and fragmentation when we insert rows into the index For the vast majority of systems, this will be a v

SQL Server 2012 is best known for its bombastic new features: AlwaysOn, Columnstore indexes, Window functions enhancements, Extended Events enhancements, and more. But there are other little and less known tweaks that might seem less revolutionary, but can make our lives much easier. Below are a few of them: 1. Adding a column with a default value is now a metadata operation Until SQL Server 2012, this task could take some time for big tables, because SQL Server had to update

A few weeks ago Kalen Delaney presented a 3-day seminar in Israel. Unfortunately, I wasn’t able to attend the seminar, but some of our consultants attended and returned from the seminar with some interesting insights. The first day was about concurrency control. Among other things, Kalen spoke about the snapshot isolation level and how row versioning works when this isolation level is used. One question was remained unanswered. Suppose you have an index on column “Col1”, and