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 48 (476 total posts)
  • How TOP wrecks performance (part 2)

    In my previous post, I showed how the vanilla version of TOP can really help performance by nudging the optimizer into picking an execution plan that is optimized for returning just a few rows instead of the entire result set. But I also showed that adding WITH TIES causes a cardinality misestimate, which may lead to suboptimal or downright ...
  • 24 Hours of PASS - Evolution of the Data Platform - The Grand Finale - Schedule Change

    I was originally schedule in the 24th slot of the upcoming 24 Hours of PASS which was to begin at 7am ET on May 26.  I called it the Grand Finale. As with many events, schedule conflicts arise. So, the Grand Finale session will now be referred to me as the Grant Finale session.  Grant Fritchey will now be speaking at 7am ET on May 26. ...
    Posted to Rick Heiges (Weblog) by RickHeiges on May 22, 2016
  • SQL Server 2016 Query Store: How to fix problems you face for slow running queries

    This article allows us to focus on a new feature of SQL Server 2016 known as Query Store. We will talk about performance issues related to the query plan choice change and how the Query Store can help us to identify queries that have become slower.   Introduction Have you ever experienced to have your system slowed down or completely down? ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on March 30, 2016
  • New Article: What's New in SQL Server 2016 Availability Groups

    I am pleased to announce that I had another article published at TechTarget.com (SearchSQLServer.com). The topic is focused on what's new in SQL Server 2016 Availability Groups.  I actually created this article a while back and finally got published. It does not have information about Basic Availability Groups, but I will be blogging about ...
    Posted to Rick Heiges (Weblog) by RickHeiges on January 20, 2016
  • A new superpower for SQL query tuners – Number of Rows Read

    There’s a technique that I’ve been using for some time now, and been looking for going even further back, which has become immediately available to everyone who can see a query plan (version permitting). Some years back (ok, it was 2010), I started to present at conferences about SARGability and residual predicates. I had a session at SQLBits ...
    Posted to Rob Farley (Weblog) by rob_farley on December 11, 2015
  • The free #eBooks series #SQLServer and .NET Blog

    The series of free eBooks ''The SQL Server and .NET Blog eBook Series'' by Artemakis Artemiou (@artemakis) collects dozens of articles explaining how to solve practical problems in these areas: Database DevelopmentDatabase AdministrationPerformance Tuning Developing SQL Server (The SQL Server and .NET eBook Series)This ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on November 16, 2015
  • Revised File & Wait Statistics Procedures

        For many years I have been using a set of stored procedures to capture and report on both the file and wait statistics inside of SQL Server and I just recently did some more modifications that I wanted to make available. Since many of you have received copies of the past revisions via conferences or articles and such I ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on September 2, 2015
  • SQL 2014 queries under a strobe light

    I just wrote a post about Live Query Statistics. Let me show you how this technology in SQL Server 2014 can be used for some amazingly cool (nerdy cool, at least) stuff. Behind the scenes, LQS uses a DMV called sys.dm_exec_query_profiles. When you run a query with SET STATISTICS PROFILE ON, the engine puts data into this DMV for every operator in ...
    Posted to Rob Farley (Weblog) by rob_farley on August 31, 2015
  • Live Query Statistics in SQL 2014, not just SQL 2016

    One of the coolest things in SQL Server 2016 is Live Query Statistics (LQS). But did you know that it’s available in SQL 2014? (Edit: Needs SP1) The thing is that we haven’t been able to view it effectively before now, before SQL Server Management Studio 2016 became available. LQS provides the ability to watch an execution plan while the query ...
    Posted to Rob Farley (Weblog) by rob_farley on August 31, 2015
  • DBTA - StretchDB, a Cool New Feature in vNext SQL Server

    Originally appearing in my monthly column at Database Trends & Applications magazine. When it comes to cloud-based database management, there are really only two players: Amazon, the value leader, and Microsoft, the innovation leader. Amazon has carved out a niche as the value leader in cloud-based database management, ...
    Posted to Kevin Kline (Weblog) by KKline on August 5, 2015
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement