Posts by Brent Ozar

What Is a Cost-Based Optimizer?

Execution Plans
0
When you execute a query, the database server has to figure out things like: Which table to process first Which index to use on that table Whether to seek on that index or scan it Which table to process next How to join the data between those two tables When to sort the data For…
Read More

[Video]: Office Hours at Diamond Beach

Videos
2 Comments
I took a break from playing with glacier leftovers at Diamond Beach to answer the questions you upvoted at https://pollgab.com/room/brento/. 00:00 Introductions 1:21 Null Pointer: When we move to Azure SQL DB, should we worry about having all our data and backups in one place? 03:27 Josh: We’re using indexed views, and we have to…
Read More

[Video] Office Hours at the Seltjarnarnes Lighthouse

Videos
0
You posted and upvoted SQL Server questions at https://pollgab.com/room/brento, and I went out for a walk on the Seltjarnarnes peninsula to the lighthouse to answer ’em. Here’s what we covered: 00:00 Introductions 00:58 Gio: Any known gotchas from using Windows Update to apply CUs to SQL 02:17 AlwaysLearningDBA: Hello Brent. A friend of mine wanted…
Read More

[Video] Office Hours: Ask Me Anything in the Reykjavik Harbor

Videos
0
You posted and upvoted questions at https://pollgab.com/room/brento to pick what you’d like to see covered in a Q&A session: Here’s what we covered: 00:00 Introductions 00:26 Mehdi: Hi Brent! What is the first step when SQL Server is overloaded? But we can still connect to SQL Server by SSMS. 02:36 Allan: Do you think learning SSIS…
Read More

[Video] Office Hours: Ask Me Anything About SQL Server at Hallgrímskirkja

Videos
6 Comments
I hang out by Hallgrímskirkja, the modern church in Reykjavik, and take your highly-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 00:18 __normally_weird (Sean C): Can you dispel the now prevailing myth that you and your wife are the only8 people in Iceland at the moment? 01:33 Andy Leonard: What “bugs” exist in…
Read More

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

Videos
2 Comments
Before Fjöruborðið opens for lunch, I answer a few of your questions from https://pollgab.com/room/brento including: 00:00 Introductions 00:29 Peter: What is your opinion about the SQL generated by Entity Framework? 02:00 Peter: When would you switch from EF to stored procedures? 02:45 Always Learning DBA: What are free resources to help me transition into an…
Read More

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

Videos
1 Comment
I sit on the porch and discuss your highly voted questions from https://pollgab.com/room/brento. Today’s discussion includes: 00:00 Introductions 00:27 DK: What was your Gordian Knot problem? 03:25 George: How exactly does locking work on INSERT INTO…SELECT FROM? 05:48 Michael: Can I tell if hyperthreading is turned on or off? 07:25 Party People: What are the…
Read More

[Video] Office Hours: Ask Me Anything at the Westman Islands Harbor

Videos
4 Comments
You upvoted questions at https://pollgab.com/room/brento, and today I’m at the harbor in Heimaey to cover ’em. Questions we talked through: 00:00 Introductions 01:00 Zach: What happens when I change a VARCHAR(MAX) to VARCHAR(2500)? 04:26 Scott: What tools do you recommend for tracking down locks involved in blocking? 07:23 Pointing out the beluga whale sanctuary 07:58…
Read More

[Video] Office Hours at the Eldfell Volcano Crater

Videos
2 Comments
You posted and upvoted questions at https://pollgab.com/room/brento, and I ascended – well, drove into – the Eldfell Volcano in the Westman Islands to answer ’em: Questions we covered in the video: 00:00 Introductions 01:55 Do you notice big improvements for physical servers over virtual servers? 05:14 Why aren’t my SQL Servers using all of the…
Read More

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

Videos
1 Comment
You’ve got questions, I’ve got answers. Welcome to another edition of Office Hours, where you post your questions here, upvote the ones you’d like to see me talk through, and I do your bidding: Questions we covered this week: 00:00 Introductions 01:30 Are DBAs transitioning to other roles, and why? 04:48 Why is it hard…
Read More

Most T-SQL Queries Don’t Even Try to Handle Errors.

T-SQL
44 Comments
David Tovee asked a great question in yesterday’s Mastering Query Tuning class. He asked his fellow students, “How many of you actually use TRY/CATCH?” I turned it into a Twitter poll because I wanted to check a wider audience: When the developers at my company write new queries, they use TRY/CATCH and exception handling: —…
Read More
Menu