Tag Archives: Indexes

Expert Performance Indexing for SQL Server 2012

Expert Performance Indexing for SQL Server 2012 is written by Ted Krueger (@onpnt) and Jason Strate (@stratesql) – two guys who I’ve known for a few years now. ¬†They’re fun and knowledgeable and if you ever run into them at … Continue reading

Posted in Books, SQL | Tagged , , , | 2 Comments

Microsoft SQL Server 2008 Internals

Microsoft SQL Server 2008 Internals by Kalen Delaney et al. Microsoft SQL Server 2008 Internals took me a good six weeks to finish as it had so much information to consume that I would often find myself reading for ten … Continue reading

Posted in Books | Tagged , , , , , | 2 Comments

70-451–MCITP–Designing a Database for Optimal Performance–Optimize Indexing Strategies

Requirements Optimize indexing strategies. This objective may include but is not limited to: table-valued function, views, filtered indexes, indexed views, clustered and non-clustered, unique My Take I feel like this section is a strange one. I’m not sure that I … Continue reading

Posted in SQL | Tagged , , | 2 Comments