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 7 of 23 (229 total posts)
  • Parallel Execution Plans Suck

    Summary: A deep dive into SQL Server parallelism, and a potential performance problem with parallel plans that use TOP. There was an interesting question asked by Mark Storey-Smith on dba.stackexchange.com back in October 2011.  He was looking at the execution plan for a query that counts a million rows from a virtual auxiliary table of ...
    Posted to Page Free Space (Weblog) by Paul White on May 2, 2012
  • New White Paper: SQL Server Extended Events and Notifications

    SQL Server comes with a wide array of tools for monitoring your environment. There are logs and traces that provide information when errors occur, but these are often used passively to react to events that have already occurred.  There's PerfMon, and Profiler, and loads of Dynamic Management Views to check.  But where to look? As ...
    Posted to Kevin Kline (Weblog) by KKline on April 25, 2012
  • SQL Server Performance Tuning and Optimization in Jacksonville, FL on April 27th

    One last reminder -  If you're interested in learning more about troubleshooting and optimizing SQL Server performance, please consider coming to the full-day seminar I'll be giving this Friday.  Full details are here: http://sqlperftuning.eventbrite.com/.  We'll be working some exercises, so bring your laptop with an instance ...
    Posted to Kevin Kline (Weblog) by KKline on April 23, 2012
  • Accelerate OLTP with HP and Microsoft's New High Performance Reference Architecture

    If you haven't started to read Shashank Pawar (blog), you're missing out. Shashank is part of Microsoft Australia and has been writing some very good content lately. Here's an example from the Reference Architecture for High Performance SQL Server:HP and Microsoft engineering teams have worked together to create a reference architecture to ...
    Posted to Kevin Kline (Weblog) by KKline on March 6, 2012
  • Rick Review: SQLTeach - SQL345 - 10-Mar-2010 - Kimberly Tripp

    SQLTeach (Part of the DevTeach Conferences in Canada) has enjoyed success for many years.  I enjoyed the opportunity to speak at and attend SQLTeach at various times over the years.  Since SQLTeach is part of DevTeach, the ''feel'' of the event is very different from PASS or SQLRally or even a SQL Saturday where SQL is the primary ...
    Posted to Rick Heiges (Weblog) by RickHeiges on February 15, 2012
  • Dynamic Seeks and Hidden Implicit Conversions

    Most people know that a LIKE predicate with only a trailing wildcard can usually use an index seek: SELECT p.Name FROM Production.Product AS p WHERE p.Name LIKE N'D%'; As the execution plan shows, SQL Server determines a covering range (which depends on the collation), seeks the ...
    Posted to Page Free Space (Weblog) by Paul White on January 17, 2012
  • New in 2012 - IT Horror Stories

    I do a lot of public speaking over the course of the year at many different conferences and events. I always try to carve out time during and after the presentation to take questions from the audience. While many of these questions are de riguer, I often get questions that can only be described as ''How do I handle this ... <insert IT horror ...
    Posted to Kevin Kline (Weblog) by KKline on January 2, 2012
  • Is Distinct Aggregation Still Considered Harmful?

    Back in 2008, Marc Friedman of the SQL Server Query Processor Team wrote a blog entry entitled “Distinct Aggregation Considered Harmful”, in which he shows a way to work around the poor performance that often results simply from adding the keyword DISTINCT to an otherwise perfectly reasonable aggregate function in a query.  This post is an ...
    Posted to Page Free Space (Weblog) by Paul White on December 3, 2011
  • SQL Live Monitor

    I just found this one out there and wanted to share it. It connects to an instance and show you a bunch of figures. Nothing you can't extract yourself with SQL queries, but sometimes it is just nice to have one tool which is very easy to use. Here's what it looks like when connecting to an instance with no load on it: As you can see, there ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on November 19, 2011
  • Everybody Needs a Test Harness

    When you're developing new Transact-SQL code or modifying some existing code, do you just launch directly into programming? I know that I did just that, for years. It wasn't until I was trying to performance tune some existing code that I realized I hadn't actually taken caching of data and execution plans into account. So all those modified ...
    Posted to Kevin Kline (Weblog) by KKline on October 31, 2011
« First ... < Previous 5 6 7 8 9 Next > ... Last »
Privacy Statement