[Video] Office Hours: Ask Me Anything About SQL Server


Erika and I are on the road in Iceland, roaming around the countryside, and I’m taking you with us. This week, we’re in Siglufjörður, a beautiful little oceanfront fishing village in the north. In the mornings, before Erika wakes up, I’m filming Office Hours videos to answer your questions that you post here. The first video comes to you from a park bench next to the harbor:

Questions I answered in the video:

  • 00:00 Introductions
  • 01:34 Do we need to do index maintenance on a 1TB database?
  • 04:16 Is it bad to have multiple SQL Server instances on one VM?
  • 06:40 Why isn’t there a good static code analyzer for T-SQL?
  • 09:50 Why are we getting out-of-memory errors with 780GB RAM?
  • 13:20 Brent talks to birds
  • 13:58 What should people be documenting about their SQL Servers?
  • 19:11 Should I disable automatic statistics updates?
  • 21:58 How much performance tuning is enough?
  • 24:52 Talking about Siglufjörður’s harbor

If you’ve got something you’d like to see me cover, ask your questions here, and while you’re at it, upvote other questions that you’d like to see covered. I’ll take the highest-upvoted questions and talk through ’em in an upcoming webcast.

Previous Post
Updated First Responder Kit and Consultant Toolkit for July 2021
Next Post
[Video] Office Hours: Ask Me Anything About Professional Development

17 Comments. Leave new

  • I know you love transactional replication, so here is the question:

    If I wanted to repoint a transactional replication subscription to a new client without dropping and recreating the subscription with scripts or otherwise. What system tables in the distribution database would I have to change? Also, what jobs would I have to modify?

  • David Tovee
    July 28, 2021 8:09 pm

    I was hoping to have multiple DBs on one standard SQL server and use HA with MS ‘Software Assurance’ until Brent answered this question “Is it bad to have multiple SQL Server instances on one VM?”
    I was hoping to reduce the number of SQL Servers to support but, on reflection, where we have multiple DBs on one server, some don’t play fair. It also seems you need a HA group for each DB which is a pain.
    It seems like multiple standard edition SQL Servers or one Enterprise SQL server with multiple DBs and use the ‘Resource Governor’?

    • David Tovee
      July 28, 2021 8:10 pm

      I forgot to mention, another one of Brent’s talents seems to be he can talk to feathered birds in the video!

    • Looks like you copy/pasted your comment from YouTube, so I’ll copy/paste my answer over here too, heh:

      Howdy sir! You’re welcome. Well, getting into specific HA/DR design for a server is kinda beyond what I can do in YouTube comments – that’s where the consulting comes in.

      • David Tovee
        July 29, 2021 7:08 am

        Sorry, I didn’t see your response in YouTube and I thought this was a better place to ask the question.

  • David Reabow
    July 28, 2021 8:17 pm

    Had to listen just to here you pronounce Siglufjörður 😀

  • That city is BEAUTIFUL! <3

  • Phil Edmonds
    July 28, 2021 10:24 pm

    Many thanks Brent, very interesting and informative. Enjoy your holidays!

  • Thank you – as always for taking the time to set us on the right path!

    Love the ambience, looking forward to a session in Dimmu Borgir. Or better even, a session between the puffins on Ingolshofdi. 🙂

  • ice ice baby and under pressure in the same video from ICEland, priceless


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.