Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)

  • RE: Index Column Order – Be Happy!

    Yep.  It's me, Matt.  I chuckled to myself when I saw that you had responded in this forum a few days ago.  It's a small world after all...

  • RE: Index Column Order – Be Happy!

    Also, be aware that the query uses local variables for the date range. This behavior is completely different than if you used a stored procedure with 2 date parameters...

  • RE: Index Column Order – Be Happy!

    Mike, when producing its missing index recommendations, SQL Server groups the columns into 2 buckets: all columns involved in equality predicates come first and then all columns involved in inequality...

Viewing 3 posts - 1 through 3 (of 3 total)