Business Intelligence Blogs

View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.

SQL Server Indexing Book Giveaway – Week 6 (Index Myths)

  • 14 July 2016
  • Author: JasonStrate
  • Number of views: 2083

And now for something not so different with week 6 of the Expert Performance Indexing for SQL Server book giveaway.  So far, I’ve sent out five copies of the book based on comments from these (1, 2, 3, 4, and 5) posts.

Expert Performance Indexing for SQL Server is a book I co-wrote with Grant Fritchey (Blog | @gfritchey) last summer, which can be a valuable resource to anyone building indexes on SQL Server.  As part of finishing the book, Apress sent me a number of copies of the book to share with people.  I figured the best way to share these out is to give them away to people that comment on this blog.

So here’s a topic for leaving a comment this week…

The Question

For week six, the question will focus on chapters eight, which covers index myths and best practices.  The topic for discussion in the comments this time is…

What indexing myths have you had to deal with?  Have you had trouble with those who think databases don’t need indexes?  Have you dealt with those that believe key column order doesn’t matter?  Is there one you’ve dealt with that isn’t often talked about?  Or how about an indexing best practice that you use?

If you have a story to share in this area, leave it in a comment below. After a week, I’ll select one of the comments and send that author a copy of the book.

Categories: Blogs
Rate this article:
No rating


Other posts by JasonStrate

Please login or register to post comments.