Category Archives: Performance

  1. Increasing and decreasing the performance level of your Azure SQL Database

    Leave a comment

    March 29, 2017 by Kenneth Fisher

    One of the big benefits of Azure, and in fact any of the cloud offerings I’ve seen, is the ability …
    Continue reading

    Category: Cloud, Microsoft SQL Server, Performance, SQL Database, SQLServerPedia Syndication | Tags: , , ,

  2. Queries with optional parameters

    17

    February 27, 2017 by Kenneth Fisher

    These are those queries where you are pulling for, let’s say, a first name, a last name, a state, and/or …
    Continue reading

    Category: Dynamic SQL, Microsoft SQL Server, Performance, SQLServerPedia Syndication, T-SQL | Tags: , , , ,

  3. Lead Blocker

    10

    January 18, 2017 by Kenneth Fisher

    Blocking is just part of life I’m afraid. Because we have locks (and yes we have to have them, and …
    Continue reading

    Category: Microsoft SQL Server, Performance, Problem Resolution, SQLServerPedia Syndication, T-SQL | Tags: , ,

  4. Reload a table quickly.

    4

    November 21, 2016 by Kenneth Fisher

    Sometimes loading new data or even changes into a table just isn’t going to work. You need a complete reload. …
    Continue reading

    Category: Microsoft SQL Server, Partitioning, Performance, T-SQL | Tags: , ,

  5. SQLSkills waits and latches library

    2

    November 16, 2016 by Kenneth Fisher

    SQLSkills is an amazing resource for the SQL Server community. Between their blogs, white papers, and the SQLSkills Insider emails …
    Continue reading

    Category: Microsoft SQL Server, Performance | Tags: ,

  6. New indexes, hypothetically

    1

    November 2, 2016 by Kenneth Fisher

    I saw something like this the other day. My first thought was “Hu, never seen that before.” My second thought …
    Continue reading

    Category: Index, Microsoft SQL Server, Performance, Query Plans, SQLServerPedia Syndication, T-SQL | Tags: , , ,

  7. Natural vs Artificial Primary Keys

    3

    August 29, 2016 by Kenneth Fisher

    There has been a long standing debate over the use of a natural primary key vs an artificial one. I …
    Continue reading

    Category: Index, Microsoft SQL Server, Performance, Referential Integrity, SQLServerPedia Syndication | Tags: , , ,

  8. RBAR vs Batch

    8

    August 17, 2016 by Kenneth Fisher

    Many years ago Jeff Moden (of SQL Server Central fame) came up with the concept of RBAR. Row-By-Agonizing-Row. At it’s …
    Continue reading

    Category: Microsoft SQL Server, Performance, SQLServerPedia Syndication, T-SQL | Tags: , , ,

  9. Is the network your last performance bottleneck?

    6

    July 18, 2016 by Kenneth Fisher

    Let’s say your company relies on the cloud for its servers (or maybe not, on premise networks have more options …
    Continue reading

    Category: Cloud, Microsoft SQL Server, Performance, SQLServerPedia Syndication | Tags: , , ,

  10. Altering a column in a large table: A case study

    20

    July 14, 2016 by Kenneth Fisher

    Fair warning, this is a discussion piece. I had a task, I went through several possibilities and I’m going to …
    Continue reading

    Category: Microsoft SQL Server, Performance, Problem Resolution, SQLServerPedia Syndication | Tags: , ,

« Older Entries
Newer Entries »

Follow me via RSS

RSS Feed RSS - Posts

RSS Feed RSS - Comments

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 2,542 other followers

Follow me on Twitter

@sqlstudent144

Archives

Categories

Meta

ToadWorld Pro of the Month November 2013