THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Performance   (RSS)
Showing page 1 of 46 (459 total posts)
  • Re-Inventing the Recursive CTE

    Working with hierarchies in SQL Server never fails to be absolutely fascinating. On the face of things they’re super-easy to model and seem to fit perfectly well: parent_key, child_key, self-referencing FK, and you’re done. But then you go to query the thing and there is a complete breakdown. Prior to SQL Server 2005 the product included zero ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on April 7, 2015
  • ICYMI: Query Optimization Phases, Observer Overhead, and Secrets of SP_Updatestats - SQL Server Performance

    Do you do a bit of query tuning? Then check out this treasure trove of performance tuning advice!Optimization Phases and Missed Opportunities andWorking Around Missed OptimizationsPaul White (b | t) writes two fascinating blog posts that go hand-in-hand concerning query optimization.  He goes into some deep details about ...
    Posted to Kevin Kline (Weblog) by KKline on March 23, 2015
  • ICYMI: Troubleshooting CPU, Logging Myths, Missing Indexes, and Query Tuning Examples

    Great Articles at SQLPerformance.comThere are so many good articles from SQLPerformance.com this ICYMI article that it’s hard to know which are best to highlight in the limited space. So, I’ll be arbitrary and simply choose a few of my favorite entries as we look back:Troubleshooting SQL Server CPU Performance IssuesThis outstanding ...
    Posted to Kevin Kline (Weblog) by KKline on March 16, 2015
  • Tuning Parallel Data Warehouse Queries

    Performance tuning in regular SQL Server can be addressed in a number of ways. This can involve looking at what’s going on with the disk configuration, the memory configuration, the wait stats, the parallelism settings, indexing, and so much more. But if you have a Parallel Data Warehouse (PDW) environment, then there are a lot of things that are ...
    Posted to Rob Farley (Weblog) by rob_farley on March 9, 2015
  • The SQL Sentry forum for SQL Statement Tuning

    The SQL Sentry forum for SQL Statement TuningHave you ever looked at our community site specifically dedicated to helping users tune their SQL queries, http://answers.SQLPerformance.com?You can easily upload an execution plan directly from our free Plan Explorer tool or from good ol' SQL Server Management Studio.  Once ...
    Posted to Kevin Kline (Weblog) by KKline on February 25, 2015
  • Why isn’t my filtered index being used?

    Quite often, people have filtered indexes but find they’re not being used as often as they’d like. I was reminded of this recently when I read a good post by Kendra Little from brentozar.com about filtered indexes. In it, Kendra talks about how the WHERE clause of a filtered index allows an IN clause, but not an OR clause (to quote someone from ...
    Posted to Rob Farley (Weblog) by rob_farley on February 22, 2015
  • SQL Konferenz 2015 Slide & Demo

    Last week I spoke at the SQL Konferenz in Darmstad near Frankfurt. The conference was great and I meet a lot of good SQL friends over there. For anyone interested here you can find slide & demos of the session I delivered: (Near) Real-Time Data Integration with SQL Server, On-Premises & Cloud ...
    Posted to Davide Mauri (Weblog) by manowar on February 9, 2015
  • Medians pre-SQL 2012

    SQL 2012 was a big release for working out the median in SQL Server, with the advent of the function PERCENTILE_CONT(). It’s a very elegant way of working out the median (hint, that’s the 0.5 point), even though it’s not actually an aggregate function, as I’ve written before. Plus – it doesn’t even perform well. About a year ago, Aaron Bertrand ...
    Posted to Rob Farley (Weblog) by rob_farley on January 26, 2015
  • Minimising Data Movement in PDW Using Query Optimisation Techniques

    This is a white paper that I put together recently about APS / PDW Query Optimisation. You may have seen it at http://blogs.technet.com/b/dataplatforminsider/archive/2014/11/14/aps-best-practice-how-to-optimize-query-performance-by-minimizing-data-movement.aspx as well, but in case you haven’t, read on! I think the significance of this paper is ...
    Posted to Rob Farley (Weblog) by rob_farley on December 4, 2014
  • How TOP wrecks performance (part 1)

    The TOP keyword in the SELECT clause may not be ANSI standard, but I am sure we have all used it. But do you know that it comes with two optional keywords? And have you used them? They are PERCENT and WITH TIES.   TOP   Let’s first look at the based functionality of TOP, and how it affects performance – which in fact, contrary to the ...
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement