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 33 (327 total posts)
  • For the Better Developer: When indexes are not enough

    Another month, another session for the PASS Application Development VG. This time I will be both the host and the guest :), talking about something is very close to my interests and, I think, also a key point for any developer to have success in future of AI. Here’s the session title and abstract: For the Better Developer: When indexes are not ...
    Posted to Davide Mauri (Weblog) by manowar on October 3, 2017
  • Speaking @ PASS Summit 2017

    After years and years talking about Business Intelligence and Business Analytics, this year at PASS I’ll be speaking about Application Development and how to make the best use of the data platform that Microsoft created so far. I’ve started talking about the impedance mismatch at the beginning of my career and now, after 15 year of Business ...
    Posted to Davide Mauri (Weblog) by manowar on July 24, 2017
  • T-SQL Window Functions

    I’ll soon post something on this, but let me tell you right here. If you don’t want AI to take you DEV/DBA/BI job you *need* to be smarter than AI (which is not AI at all right now, but let’s keep on playing the marketing game): one way to become smarter is to - guess! - use your brain and train it to think out of the box, practice lateral ...
    Posted to Davide Mauri (Weblog) by manowar on July 10, 2017
  • Getting Excited about my Practical Performance Monitoring Pre-Con

      I was working on the demo’s for my Practical Performance Monitoring Pre-Con at this years IT / Dev Connections in San Francisco and I have to admit I got a little giddy.  The session is geared towards helping a DBA get started in monitoring their SQL Server Instances, especially when they don’t have the ability to buy a 3rd party ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on July 2, 2017
  • Logging wait stats over time

    We all know how valuable wait statistics can be when doing performance analysis. One thing I feel is missing in SQL Server is a trail of various measures, for instance wait stats. I really wish Microsoft could include something in this area, which can be used as a baseline. I recently fount this, from the Tiger Team. It looks promising, ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on June 8, 2017
  • Explaining Activity Monitor

    This post is not about how to use the Activity Monitor (AM) tool in SQL Server Management Studio (SSMS) – there are loads of such posts written already. Also, it is not about dissing AM, you will find such posts as well. What I want to do is to explain the information in AM, for instance what time span the information covers. I see lots of ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on February 16, 2017
  • This month’s T-SQL Tuesday post

    …is not here. It’s over at https://sqlperformance.com/2017/01/sql-performance/estimated-number-of-rows-to-be-read I write about the new EstimatedRowsRead property, and in particular, about how Microsoft responded so well to the Connect Item I created, requesting the feature. @rob_farley
    Posted to Rob Farley (Weblog) by rob_farley on January 9, 2017
  • SQL Nexus 5.5.0.1

      The SQL Nexus set of utilities are some of the most under utilized tools available to the SQL Server community. I used and touted the RML utility for many years to help people analyze trace information very fast and easily. Eventually XE traces were added to the list along with much more.  This blog post link will give you a pretty ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on November 20, 2016
  • Misconceptions on parameter sniffing

    In my previous post, I explained the basic of parameter sniffing, and then built on that to explain the lesser known mechanics of variable sniffing and cardinality sniffing. However, I also sneakily inserted a few comments on misconceptions about the performance impact of parameter sniffing, with the promise to explain in more detail later. Well … ...
  • The sniffing database

    Your SQL Server instances, like people with hay fever that forget to take their antihistamines during summer, is sniffing all the time. Sniffing is a trick employed by the optimizer in an attempt to give you better execution plans.   The most common form of sniffing is parameter sniffing. Many people know about parameter sniffing, but there ...
1 2 3 4 5 Next > ... Last »
Privacy Statement