Skip to content
  • Home
  • About
  • Resources
  • Twitter
  • LinkedIn
Search
Close

SQL TECH BLOG

Month: November 2016

Query Tuning 101: Debugging a procedure

November 30, 2016December 13, 2016 Daniel JanikLeave a comment

I was recently asked to help tune a stored procedure that has been historically taking between 55 and 60 seconds to complete. Overall the code wasn’t too complex but getting to the root cause did surprise me a bit.

Read More »

Query tuning 101: How to measure Query Plan I/O cost

November 17, 2016November 30, 2016 Daniel JanikLeave a comment

If you’re a DBA or a developer chances are you’ve looked at a query plan or two. While looking at your plan you may have noticed that each operator has a cost. Did you know that the cost is measurable?

Read More »

Query tuning 101: Problems with IN ()

November 10, 2016November 30, 2016 Daniel Janik11 Comments

If you’re a DBA or database developer, chances are you will have to write or rewrite queries from time to time. Rewriting may be for new features or simply to improve the performance of existing code.

Read More »

Welcome to SQLTechBlog.com. We are dedicated to posting high quality news and blogs concerning Microsoft SQL Server.

I'm speaking!

  • 2016-06-11 | SQLSaturday #528 | Curacao
  • 2016-07-14 | Query Plan Analysis | MSSQLTips Webcast
  • 2016-08-06 | SQLSaturday #515 | Baton Rouge
  • 2016-08-13 | SQLSaturday #550 | San Antonio
  • 2016-08-27 | SQLSaturday #553 | Oklahoma City
  • 2016-09-24 | SQLSaturday #563 | Dallas
  • 2016-10-26 | PASS Summit 2016 | Seattle
  • 2017-04-20 | PASS NTSSUG | Dallas
  • 2017-10-07 | SQL Saturday #678 | Orlando
  • 2018-06-09 | SQLSaturday #773 | Los Angeles
  • 2018-06-23 | SQLSaturday #766 | Houston
  • 2018-08-11 | SQLSaturday #749 | Baton Rouge

Other Blogs I like

  • Shane O'Neill
  • SQLKitten.com

Follow me

  • View @SQLSME’s profile on Twitter
  • View sqlsme’s profile on Instagram
  • View danielcjanik’s profile on LinkedIn

Subscribe

RSS Feed

Follow SQL TECH BLOG on WordPress.com

Recent Posts

  • Azure Purview Best Practice: Naming your scans
  • Using PyApacheAtlas to import SQL Server extended properties to Azure Purview
  • AWS Community Builders #AWSCommunity
  • Running SQL Server in Google Cloud Platform
  • Living in the new normal as a data engineer

Tags

#ThanksToAll Administration AWS Azure Best Practice bug? Career Clippy Compliance Data Catalog DBA Development Gaming gdpr Linux Management Studio Monday comic Monitoring Off Topic Oracle PASS Performance Purview Query Plans Query Tuning security Speaking SQLOpsStudio SQL Saturday sql server SQL Server 2016 SQL Server 2017 Storage Tools

Categories

  • Administration
  • Arduino
  • AWS
  • AWSCommunity
  • Azure
  • Azure Data Factory (ADF)
  • Azure Data Studio
  • Career
  • Comic
  • Compliance
  • DBA
  • Development
  • Gaming
  • GCP (Google Cloud Platform)
  • Google
  • Governance
  • Help Wanted
  • IoT
  • Learning
  • life
  • Linux
  • Migration
  • MSDOS
  • Off Topic
  • Oracle
  • Performance
  • PowerShell
  • Purview
  • Python
  • Query Plans
  • Query Tuning
  • security
  • Speaking
  • SQL Saturday
  • sql server
  • SQLOpsStudio
  • Storage
  • Sustainability
  • Thank you
  • Tools
  • Uncategorized

Archives

  • August 2021
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • February 2020
  • May 2019
  • February 2019
  • September 2018
  • July 2018
  • June 2018
  • May 2018
  • April 2018
  • March 2018
  • February 2018
  • December 2017
  • November 2017
  • October 2017
  • September 2017
  • August 2017
  • July 2017
  • June 2017
  • May 2017
  • April 2017
  • March 2017
  • February 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • July 2016
  • June 2016
Blog at WordPress.com.
Back to top
  • Follow Following
    • SQL TECH BLOG
    • Join 67 other followers
    • Already have a WordPress.com account? Log in now.
    • SQL TECH BLOG
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar