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 47 (463 total posts)
  • ICYMI - Predicate Logic, Four Things I Wish I'd Known Sooner, Transact-SQL Bad Habits, Rewriting Queries to Improve Performance

     My weekly digest of  great articles originally appearing at SQLPerformance.com.Why Not Seek PredicatePaul White ( b | t ) proves, once again, why he is the best in the business when it comes to debugging a SQL Server query. In this post, Paul gives you a step-by-step breakdown of a query that goes astray ...
    Posted to Kevin Kline (Weblog) by KKline on August 4, 2015
  • ICYMI - Recommended Intel Processors For SQL '14, Should Indexes Be In The Key Or Included, Comparing Windows Azure VM Performance

     My weekly digest of  great articles originally appearing at SQLPerformance.com.  Grouped Concatenation in SQL Server and Grouped Concatenation: Ordering and Removing DuplicatesIn these two related blog posts, Aaron Bertrand ( b | t ) of SQL Sentry takes on the safest and most ...
    Posted to Kevin Kline (Weblog) by KKline on July 28, 2015
  • Heading to SQL Sat NYC!

    I will be speaking at SQL Sat 380 in NYC on the topic of Basic Performance Monitoring with Perfmon.  I have delivered this session many times and is usually well attended.  The session is geared for the person who has heard of Perfmon but not used it.  This is very much a 100 level offering. The last time that I was in NYC for a ...
    Posted to Rick Heiges (Weblog) by RickHeiges on May 21, 2015
  • Tuning slow spatial queries in SQL Server

    Even with the right indexes in place, spatial queries in SQL Server are often too slow – but they needn’t be. Two of the most commonly found patterns of query in the spatial world are when you’re looking for the nearest thing to where you are (which I’ve written about before), and when you’re looking for the points that are within a particular ...
    Posted to Rob Farley (Weblog) by rob_farley on April 28, 2015
  • 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
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement