Root

Tag: root

Indexes: Do Included Columns Always Go on a Non-Root Page? (video)

Indexes: Do Included Columns Always Go on a Non-Root Page? (video)

Recently, I was thinking about nonclustered indexes in SQL Server, and how included columns are stored.

Is SQL Server smart enough to optimize the storage for small indexes with includes? Find out in this free seven minute video.

Continue reading

The Next 24 Hours of PASS Event: Announcement and Call for Presenters

The Next 24 Hours of PASS Event: Announcement and Call for Presenters

on December 2, 2010

Tonight I checked in on the Twitterverse and saw that Jason Strate announced a new blog post about the next 24 Hours of PASS event.

Continue reading