Search Results for “parameter sniffing”

[Video] Office Hours: Answering Your Microsoft Data Platform Questions

Last Updated October 24, 2022

Ask questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me cover. Here’s what we covered today: 00:00 Start 00:59 neil: is it dangerous/risky to expand a drive in azure with SQL data files on it? sql on azure vm. dont know what happens behind the scenes 02:07 Brett: I am a consultant…

Let’s Hang Out in Person at the PASS Summit Next Month.

Last Updated October 20, 2022

Brent Ozar

#SQLPass

I’m so excited to see everybody again at the PASS Data Community Summit in Seattle on November 14-18. I’M BACK IN PERSON! Here’s the crazy part: I’m not going to attend a single session. Not one. (Well, except the ones I’m teaching, and the keynotes.) Instead, I’m gonna spend every single conference hour hanging out in…

[Video] Office Hours Silent Edition

Last Updated September 29, 2022

Brent Ozar

Videos

Okay, I, uh, forgot to unmute the microphone for this one: So here are the answers in text form instead. <sigh> Thank goodness it was a speed round! Mike: When Brent Ozar’s certification exams for SQL Server will be available? Looking forward to having exams like “Fundamentals of QT”, “Mastering Server Tuning” etc, so you…

Free Live Webcast: Why is One Query Sometimes Slow and Sometimes Fast?

Last Updated September 28, 2022

Brent Ozar

SQL Server

Sometimes the exact same query goes slow out of nowhere. Your current fix is to update statistics, rebuild indexes, or restart the SQL Server. It works, but you don’t know why. The single most common reason is parameter sniffing. SQL Server “sniffs” the first set of parameters for a query, builds an execution plan for…

What’s New in SQL Server 2022 Release Candidate 0: Undocumented Stuff

Last Updated August 25, 2022

Brent Ozar

SQL Server 2022

Microsoft has an official list of what’s new in 2022 overall, but here I’m specifically focusing on system objects that might be interesting to script developers like you and I, dear reader. New stored procedure sp_get_table_card_est_and_avg_col_len – I assume the “card” refers to statistics and cardinality, not Hallmark. SQL Server has historically struggled with memory…

Estimated and Actual Plans Can Have Different Shapes.

Last Updated August 4, 2022

Brent Ozar

Execution Plans

A reader posted a question for Office Hours: Hi Brent, What is your take on Hugo Kornelis’s explanation of execution plan naming. As her his explanation, estimated exec plan is simply an execution plan whereas actual execution plan = execution plan+run-time stats. Do you agree that the naming is flawed and confusing? – Yourbiggestfan I…

Office Hours Speed Round: Text Edition

Last Updated July 13, 2022

Brent Ozar

Production Database Administration

Not all of the questions you post at https://pollgab.com/room/brento are hard. Some of ’em can be answered in one line: Q: accidentalDBA: Hi Brent, My friend is moving from two physical servers (production + failover) to VMs on the same host and SAN. His manager wants to keep log shipping as a DR solution. I…

This Is Your Last Chance to Attend My Mastering Classes Live This Year.

Last Updated July 9, 2022

Brent Ozar

Conferences and Classes

You’ve conquered my Fundamentals classes, and you’re ready to take it up a notch. You know you can get the recordings of my Mastering classes, but you prefer the interaction of live classes – the ability to ask questions live, have me go off-topic for demos, and block out your calendar to make sure you…

Here’s What I’m Teaching at the 2022 PASS Summit.

Last Updated July 7, 2022

Brent Ozar

#SQLPass

The lineup for the PASS Data Community Summit is out, and in addition to my pre-conference workshop on Mastering Parameter Sniffing, I’m also teaching two sessions: Everything You Know About Parallelism Is Wrong. Just because you see parallelism icons on execution plans doesn’t mean the query went parallel. SQL Server doesn’t load-balance work across CPU cores.…

4.8 Tuning usp_RptAvgAnswerTimeByTag

Last Updated June 17, 2022

Brent Ozar

In this one, let’s see if we can reduce the smell of parameter sniffing just by tuning indexes alone:

To access this incredible, amazing content, you gotta get Mastering Parameter Sniffing – Live Classes + Instant Replay, 1 Year Access, Mastering Parameter Sniffing – Instant Replay Recordings Only, 1 Year Access or Recorded Class Season Pass, or log in if you already shelled out the cash.

[Video] Office Hours: Vail Fireside Chat

Last Updated June 9, 2022

Brent Ozar

Videos

You posted and upvoted questions at https://pollgab.com/room/brento, and I sat down by the fire on a chilly evening in Vail, Colorado to answer ’em. I was driving cross-country, heading back from a road trip to see my mom. Here’s what we covered: 00:00 Introductions 00:46 Ms. Cosmos: What are the top traits for the perfect…

04 How to Pass In Multiple Rows

Last Updated June 7, 2022

Brent Ozar

The delimiter approach we used in the last module fails when: All possible delimiter fields are in use We need to pass in multiple columns We want to avoid the CPU overhead of shredding strings In this module, we’ll talk about the two most common ways to pass in rows to a stored procedure. Video…

To access this incredible, amazing content, you gotta get Recorded Class Season Pass, or log in if you already shelled out the cash.

00 Prerequisites Before the Class

Last Updated June 6, 2022

Brent Ozar

Hi, Brent here! I’m really excited to welcome you to class. Get your brain ready by taking the classes in order. Before you take this class, take my free How to Think Like the Engine class. I have a ton of other classes around fundamentals, like index & query tuning, but you don’t have to take those…

Office Hours Speed Round: Text Edition

Last Updated May 31, 2022

Brent Ozar

Production Database Administration

Some questions that come in at https://pollgab.com/room/brento have such straightforward answers that I don’t need to cover them on video. It’s time for a rapid-fire speed round: Q: Uncle Buck: Is there a good way to tell if a given include column for a NC index is being used at all? No. Q: Steve E:…

Never been to a SQL Server training class? Let’s fix that.

Last Updated May 22, 2022

Brent Ozar

Company News

You love learning from me. You’ve attended some of my free online streams, read my blog posts, and you use the First Responder Kit. You enjoy my laid-back, humorous approach to sharing what I’ve learned over the years. You love live classes. You’ve tried watching recordings or stepping through demos yourself, but…you just can’t block…

Get 25% Off Training – This Week Only!

Last Updated April 1, 2022

Brent Ozar

Company News

I did huge price cuts this month across the board. My individual Mastering class recordings used to be $995. Now it’s just $395 for Mastering Index Tuning, Mastering Query Tuning, Mastering Parameter Sniffing, or Mastering Server Tuning. The Recorded Class Season Pass: Mastering used to be $2,395 for all of my Masters classes. Now it’s…

[Video] Office Hours: San Diego Office Edition

Last Updated March 24, 2022

Brent Ozar

Videos

I’m back in the US at my home studio in San Diego, so I did a live Office Hours session. Post your questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me cover. Here’s what we covered today: 00:00 Introductions 00:41 WTF_SQLServer!?!: I have a some dbs that take nearly 6 hours each…

[Video] Office Hours: Ask Me Anything at Sunset on the Balcony

Last Updated March 21, 2022

Brent Ozar

Videos

Ah, sunset – time to kick back on the balcony, watch the ocean, and discuss SQL Server. You post questions at https://pollgab.com/room/brento/, upvote the ones you’d like to see me answer, and I discuss ’em: 00:00 Introductions 00:30 iAmGroot: Hello Brent, my friend has a VLDB and he’s asking what is a good strategy to…

New Lower Prices on My Mastering Class Recordings and End-of-Year Live Class Season Pass

Last Updated March 28, 2022

Brent Ozar

Company News

If you’ve been watching my Instagram feed or any of my recent Office Hours videos, you’ve noticed that I’ve moved down to Cabo San Lucas, Mexico. I’m absolutely loving it, having a great time watching whales, sitting on the beach, and sipping margaritas. It turns out that the cost of living in Mexico is cheaper than…

SQLBits 2022 Day 1 Keynote

Last Updated March 10, 2022

Brent Ozar

SQLBits

Conferences are back, baby! I’m in London for SQLBits 2022, the biggest Microsoft data conference in Europe. This year’s theme is classic video games, and it’s been really cool to see the 8-bit logos and games all over the ExCel Center. Today is the Microsoft keynote. It’s called Level Up with Azure Data, hosted by…

Search Results for “parameter sniffing”

Hi! I’m Brent Ozar.