SQL 2012 table read performance

  • Tom_Sacramento (5/20/2015)


    Hi Grant - I should rephrase my statement - the book has been very helpful and elucidating - just could not correlate this scenario with the book so I needed to ask for help. Thank you

    Yeah it wouldn't be. I went and made the classic mistake I always caution others about, assuming a scan is automatically a problem.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • Most of (99+%) there is a discrete list of columns. Unfortunately I will end up parsing the binary data in the LOBs for another project.

    Thank you for your help here, and for all the years of writing and helping so many 🙂

    Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply