Office Hours: Cartagena, Colombia скачать в хорошем качестве

Office Hours: Cartagena, Colombia

Before heading out to Old Town for sightseeing, I went through your top-voted questions from https://pollgab.com/room/brento. Here's what we covered today: 00:00 Start 00:44 Haydar: Is there a good way to suppress part of TSQL batch from showing the query plan in SSMS but having the rest of the batch show the query plan? 02:13 Mike: Hi Brent, so simple blocking on a busy server, can cause a failover ? Is it because of exhaustion of thread workers, resulting in THREADPOOL waits? But I can't understand the mechanism, how this can lead to failover - could you please explain ? 03:03 Greef Karga: Please describe the most strict / locked down environment you have worked in and the challenges it posed. 06:11 Q-Ent: Hi Brent. Have you ever used buffer pool extension as an option for better performance? 07:29 Hangman: When is sp_whoisactive context_switches a useful metric for performance troubleshooting? 08:36 AFriendOfMineAsk: Howdy Sir! Our CTO wants a monthly dashboard of all Production SQL Servers, can you please give some advice or any tips on what KPIs should include or should i have to start looking for a new job? Thanks and have a great day Sir! 09:57 Jester: What tool do you like to use to find the worst performing queries with implicit conversions? 10:55 Yaakov: What is the best way to print the line number currently executing inside a TSQL Sproc? 11:45 AM, no I'm not a morning person.: using where X in (1,2,3,4,5, etc) for selecting random sets of items. Is there any performance reason not to do this and instead use parameters or put them into a temp table first? Is it right to assume this won't be able to be a cached query? 12:59 Mike: Since 2005, new version of SQL Server had been released every 2, maximum 3 years. What is your opinion on when the next version (after 2022) will come out ? Will it be late 2024, sometime in 2025, or later, and why ?