I first answered these while standing at a harbor in Maine, but upon arriving home, I realized my camera had failed to record any audio. Doh! So I took the list of questions from https://pollgab.com/room/brento and streamed ’em from my home office in Vegas instead.
Here’s what we covered:
- 00:00 Start
- 02:51 Furkan: Hello Brent,while trying to restore a database in SQL Server 2017 instance to SQL Server 2019 instance,I got the error database running the upgrade step from 901to902 during the restore process.(Error 3013,Level 16,State 1)
- 04:01 Pixma: When measuring a query duration I would typically set getdate() to a var and then use datediff() between it and the current getdate(). Do you think this is sufficient?
- 05:12 MyTeaGotCold: Where should I go if I want to master SSMS?
- 06:02 S. Leininger: Back in the day, what was your first computer?
- 07:58 D. Zoolander: When should you monitor query performance with Application Performance Monitoring software vs when should you monitor query performance with SQL Performance Monitoring software?
- 09:26 Q-Ent: Hello Brent, If we face blocking problems due to lock escalation, is it a good idea to change the behaviour with (Alter Table set etc) ?
- 10:53 gserdijn: A nightly maintenance job triggered UPDATE STATS with a sample on a largish table. Since no rows were updated before Ola’s IndexOptimize kicked in, the stats were not updated with the specified 100%. Should I consider setting parameter @OnlyModifiedStatistics to ‘N’ ?
- 12:15 Grant: Does statistics parser web app accept pull requests?
- 12:43 magdagessler: Starting in October, I will begin working as a full-fledged SQL Server DBA. Thank you sir for sharing your knowledge
- 13:31 Artis Leon Ivey Jr: What is your opinion of SQL VM backup to URL with Azure storage account?
- 14:14 SQL Noob: Hi, what would you suggest as the best option to transfer a table with say 10 million records from on sql server to another, in 1 go.
- 15:18 G Auðunsson: How do PostgreSQL blogging opportunities compare with MSQL blogging opportunities?
- 16:27 Montro1981: Hi Brent, greetings from the Netherlands. As you are aware I have been putting some work into FRTK recently, what kind of PR do you like more:
- 17:50 Eli: Hi Brent – We’re struggling with PAGELATCH_* waits on TempDB GAM pages on our 96 core enterprise SQL Server. Using 24 TempDB files currently. Training suggests adding more files, and documentation suggests 4x increments, but 96 TempDB files sounds like a lot. Thoughts?
- 20:40 Mobius: What is the best training resource for performance tuning native SQL backup / restore?
- 21:16 marcus-the-german: I Brent, is the buffer cache hit ratio value a server metric or does it depend on the database in use?
- 21:44 Piotr: Does including IO stats / query plan in SSMS adversely query performance?
- 22:24 ZappyDBCC: Hi Brent, we have an application with a large XML column. We don’t query it, but we added a query with WHERE IS NOT NULL on it, The database tried to create a stat, which generated a storm of IO, the query timed out and the stat wasn’t created.
- 23:28 HerdOfPuffins: Hi Brent. When you come in to look at a new system, are there any checks that you do differently if the database size is measured in Terabytes?
- 24:40 W. Annabe Smarter: We are about to upgrading few SQL servers. The DB’s are at compat lvl120. I think we should stay here a few weeks before going to lvl150. Is this a bad idea? Is there tings that just not would work in lvl120?
- 25:28 Junco: What kinds of features are enabled out of the box in Enterprise vs Standard? I went through an upgrade last year from 2008 R2 Ent to 2019 Standard and saw a big performance decrease
- 27:06 hamburger sandwich: How do you handle maxdop and cost threshold for parallelism on servers with multiple instances on the server?
- 28:51 Montro1981: In a recent webinar for some storage provider you had a deadlock demo on the StackOverflow database. Is that code available somewhere?
