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 2 of 48 (474 total posts)
  • ICYMI - Adding Filtered Indexes, Wait Statistics, Comparing Windows Azure Performance

    Some of my favorite articles originally appearing at SQLPerformance.com. Dirty Secrets of the CASE ExpressionAaron Bertrand ( b | t ) of SQL Sentry takes a look at some unexpected behavior with the CASE expression and some of its derivatives. Did you know that Aaron is both an uber-genius and ...
    Posted to Kevin Kline (Weblog) by KKline on July 21, 2015
  • ICYMI - Read Committed Snapshot Isolation, How Automatic Updates to Statistics Can Affect Query Performance, #temp table

    Some of my favorite articles originally appearing at SQLPerformance.com. Read Committed Snapshot IsolationPaul White ( b | t ) has been doing a phenomenal series on SQL Server behavior under each of the major isolation levels. This particular post details the inner workings of READ COMMITTED SNAPSHOT, but there ...
    Posted to Kevin Kline (Weblog) by KKline on July 14, 2015
  • ICYMI - Avoiding Performance Tuning, Wait Statistics, Incremental Statistics

    Some of my favorite articles originally appearing at SQLPerformance.com. Avoiding Knee-Jerk Performance TuningPaul Randal of SQLskills.com starts a new series on knee-jerk troubleshooting, discussing many areas where SQL Server folks jump to conclusions when trying to fix a performance issue.Knee-Jerk Wait Statistics: ...
    Posted to Kevin Kline (Weblog) by KKline on July 7, 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
< Previous 1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement