• Home

  • Services

    • Query Performance Tuning
    • Security Audit
    • Database Recovery
    • Medical Data Management
  • Contact

  • Process and Pricing

    • Frequently Asked Questions
  • Buy Tickets

    • Cart
  • DBA Blog

  • More

    Use tab to navigate through the menu items.
    MiniMe to the rescue - Simple but effective performance tuning trick

    MiniMe to the rescue - Simple but effective performance tuning trick

    Happy Thanksgiving! We wish everyone a great thanksgiving and if you are stuck babysitting SQL server, we salute you! You suppor the infrastructure of the modern world. And that's a noble thing. Here's another SQL Query performance optimization tip that is so simple in concept and actually works pretty well, often cutting down query execution time two or three folds. If you are joining a big table many times in a query, consider plucking off the small subset of that big table
    Featured Posts
    If the SQL Server service does not start in a VM, check this:

    If the SQL Server service does not start in a VM, check this:

    Recent Posts
    ScaleIO SAN - Great for VMware, Not so great for SQL Server

    ScaleIO SAN - Great for VMware, Not so great for SQL Server

    IsDST function for SQL Server

    IsDST function for SQL Server

    Finally, a mirrored drive!

    Finally, a mirrored drive!

    Deciding between Availability Group and Clustering - Episode IV: Software side of the story

    Deciding between Availability Group and Clustering - Episode IV: Software side of the story

    Availability Group is a Klingon Warrior

    Availability Group is a Klingon Warrior

    Out of space? SQL dead? Here's what you do.

    Out of space? SQL dead? Here's what you do.

    Yep. We are SQL consultants, and are telling you to stop using SQL.

    MiniMe to the rescue - Simple but effective performance tuning trick

    MiniMe to the rescue - Simple but effective performance tuning trick

    SQL Server Simple Facts

    Quick query to return currently restoring databases

    Archive
    • April 2016 (1) 1 post
    • April 2015 (1) 1 post
    • January 2015 (1) 1 post
    • December 2014 (4) 4 posts
    • November 2014 (1) 1 post
    • August 2014 (1) 1 post
    • July 2014 (1) 1 post
    • June 2014 (1) 1 post
    • May 2014 (1) 1 post
    • April 2014 (1) 1 post
    Search By Tags
    No tags yet.
    Follow Us
    • Facebook Basic Square
    • Twitter Basic Square
    • Google+ Basic Square
    • facebook
    • Twitter Round
    • googleplus
    • flickr

    © 2014 SATO Database Architects, LLC. SQL Server, SQL Azure are registered trademarks of Microsoft Corporation.