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.
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?
M – unfortunately, I only answer questions from people smart enough to read the blog post and follow basic instructions, and you didn’t make the cut.
Dang, Brent lives in Iceland, but comments from Burnland
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’?
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:
Sorry, I didn’t see your response in YouTube and I thought this was a better place to ask the question.
Had to listen just to here you pronounce Siglufjörður 😀
I continuously forget that the ð isn’t pronounced d. (sigh)
Really off topic question 🙂
Is it easy to type all the special characters with a regular keyboard? I imagine you aren’t have to do all the crazy unicode “alt keyboard sequences”.
I just Google and then copy/paste, hahaha.
That city is BEAUTIFUL! <3
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. 🙂
Hahaha, I do indeed have a puffin session recorded & coming up!
ice ice baby and under pressure in the same video from ICEland, priceless