Rails Envy Podcast: #101: Let's put another shrimp on the barbie!

Rails Envy Podcast

Episode #101 Let's put another shrimp on the barbie!

Running time
0h14m
File size
14.00MB

Download Original File | View original post

Episode synopsis

Speaker: Don Vilen, Chief Scientist, Buysight & former Microsoft SQL Server Team Member

This session covers the basics of Filtered Indexes and Sparse Columns, and then dives into the areas where they work well—and not so well—both together and separately.  Don will show demos that show how they work and when they work well. 

You Will Learn:

  • About Filtered Indexes and Sparse Columns, both powerful additions to SQL Server
  • When to use them separately and together so you can apply them appropriately
  • How to save index space and improve performance with Filtered Indexes and Sparse Columns

Don Vilen was on the SQL Server team at Microsoft for 13 years and helped develop six versions of SQL Server.
 
Before joining Buysight in October 2010, Don Vilen was Principal Architect at Scalability Experts for nearly 3 years, in Seattle, New York City, and around the world, working with Microsoft SQL Server database customers, guiding them through complex performance, upgrade, migration, and consolidation projects. 

Don was on the SQL Server team at Microsoft from to 1994 to 2007 as the Program Manager on the Storage Engine component of SQL Server, focusing on high availability and the storage of large objects.

 

You might also like...

Comments

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Always code as if the guy who ends up maintaining your code will be a violent psychopath who knows where you live.” - Rick Osborne