[Video] Office Hours: Lots of Good SQL Server Questions


At https://pollgab.com/room/brento, post the questions you’d like to get my opinion on, and I’ll take a break every now and then at the office and go through ’em.

Here’s what we covered in this episode:

  • 00:00 Start
  • 01:08
  • #ARRRRRGH: Hi Brent. Have you seen anybody put good visualisations on top of sp_Blitz? Im trying to build something in Power BI to look at our entire estate and looking for inspiration
  • 02:33 Pradeep: Hi Brent, I am a Dev DBA. I use of SET STATISTICS IO ON to identify heavy logical reads and tune indexes to minimize it. I got better results also. Production DBA says reducing physical reads only will add value and logical reads not. Your thoughts please.
  • 04:01 MancDBA: Hi Brent, how dedicated were/are you when it came to getting better knowledge about SQL Server. Did you ever study at the weekends/evenings or did you get enough knowledge throughout the working week? Cheers.
  • 06:03 The Net Demoter: When should you not enable Query Store for SQL Server?
  • 06:44 Venkat: What is your opinion of the new query_antipattern extended event in SQL 2022?
  • 10:57 Lakshmi: Do you have any good use cases for temporary SQL stored procs?
  • 12:23 Deepak: Do you think ChatGPT will result in the re-birth of Microsoft English Query for SQL Server?
  • 14:17 CKI: What tool do you recommend to check database for sql injection vulnerability?
  • 14:54 Bruce Un-Mighty: Does SSMS execution time in the lower right include or exclude the time required to render the results grid?
  • 16:20 Dipesh: How do you know when SSMS plan operator times are individual or cumulative?
  • 17:28 Maksim Bondarenko: How do You deal with “Transaction Log Larger than Data File” situation when a database in AlwaysON Cluster with Syncronous replica?
  • 18:42 Parminder: Is there value in learning PowerBI for the SQL DBA?
  • 20:24 Deepak: What Azure SQL DB features do you think we can expect to flow down next to traditional SQL Server?
  • 23:48 Dr. Zaius: Hi Brent, have you ever used Adam Machanic’s TOP (max bigint) technique as an alternative to the X-acto method of using temp tables to phase query executions? Any rules of thumb on which technique to use in a given situation?
  • 24:35 Yousef: What is your opinion of OPTIMIZE_FOR_SEQUENTIAL_KEY in SQL 2019?
  • 26:11 Eli: Hi Brent, do you have a rule of thumb or training that teaches about the smallest table size you’ll index? I’ve got some ~8k tables that are slowing down a query with millions of scans, but my hunch is that I should be focusing on reducing the number of scans instead of indexes.
  • 27:32 Mars: Hi Brent, would you reccomend using firstresponderkit for benchmarking?
  • 29:04 neil: Is there a way to MAXDOP someone else’s troublesome query (third party application dashboard hogs all the cpu cores). Like MAXDOP a specific sproc or something like that?
  • 31:09 GuaroSQL: Hey Brent! how are you? Is First Responder Kit working fine in SQL server 2022? we are thinking of migrating, but we are using a lot First Responder Kit and we want to keep using it.
  • 32:22 Eduardo: When running sp_blitzfirst, should it be run on the DAC connection?
Previous Post
[Video] How to Use ChatGPT to Write WordPress Blog Posts
Next Post
[Video] Office Hours: DBA & Developer Relationships

5 Comments. Leave new

  • Carlos Benito
    July 5, 2023 5:49 pm

    Bruce Un-Mighty: Does SSMS execution time in the lower right include or exclude the time required to render the results grid?
    Yes, it does include it but …

    run the query is SSMS with tools > options > query results > results to grid > discard results after execution.

    and compare the time.

  • gary melhaff
    July 6, 2023 11:15 pm

    Brent, your approach to tuning for logical I/O has revolutionized my approach to tuning after watching one of your tuning videos last year. I also at first questioned its wisdom having been raised with the idea you always tune for physical I/O. I feel quite embarrassed about not knowing about this before. I’m going to just blame you for not telling me earlier ok? 🙂

  • Brent …. something seemed to go a tad wrong in that bit about the Query Store. Did you actually say you should switch it off on versions 2016, 2017 and later? It only became available in 2016 and it goes very much against the advice of Microsoft to switch it off … in fact, it’s switched on by default now. It has greatly helped me in the past and I love it. Sure there may be edge cases in it causing performance issues but surely the positives massively outweigh the negatives?

    • May want to rewatch it again – the question was, “When should you not enable Query Store for SQL Server?” and I answer it very specifically. Cheers!


Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.