Traditionally, we want our Clustered Index to have the following attributes: Narrow: So that our clustered index and the non-clustered...

SQL Server 2012 is best known for its bombastic new features: AlwaysOn, Columnstore indexes, Window functions enhancements, Extended...

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...