Product has been added to your cart.

Search Results for “execution plan”

[Video] Office Hours: 30 Minutes of Rapid-Fire (And a Little Burnination)

Last Updated July 12, 2023

Almost all of today’s questions from https://pollgab.com/room/brento were great! Well, except two. Here’s what we covered: 00:00 Start 02:13 Andrei: What’s the appropriate response/punishment for developers who insist on storing json and xml in nvarchar(max) fields? 03:43 JustGoogleIt: What are your thoughts on Jeff Moden’s “Black Arts” Index Maintenance — GUIDs v.s. Fragmentation? How would…

[Video] Office Hours: As They Pour My Patio Concrete Edition

Last Updated June 26, 2023

I can finally see the finish line in my backyard renovation, now that the concrete’s going in. I took a break from watching the construction folks to go through your highly upvoted questions at https://pollgab.com/room/brento: Here’s what we covered: 00:00 Start 02:03 Fabricator: Hi Brent, what is your take on the recent lunch of Microsoft…

[Video] Office Hours: 45 Minutes of SQL Server Q&A

Last Updated May 4, 2023

It’s a long one, folks! I went through almost 30 of your questions from https://pollgab.com/room/brento to get your learn on: Here’s what we covered: 00:00 Start 00:30 Jr Wannabe DBA: Hi Brent, recently you talked about linters; do you recommend any for T-SQL? I tried a few randomly from Google search, they are useless.…

How to Go Live on SQL Server 2022

Last Updated April 25, 2023

SQL Server 2022

You’re planning to migrate to SQL Server 2022, and you want your databases to be faster after the migration. This is NOT a blog post about how to migrate – that’s the same as it’s been for a long time. Go build the new 2022 servers, and use log shipping or database mirroring to sync…

Office Hours Speed Round, Easy Text Answers Edition

Last Updated April 18, 2023

Production Database Administration

Some of the questions y’all post at https://pollgab.com/room/brento have easy one-line answers. Let’s knock ’em out: George: Hi Brent, what recently has been the most challenging/surprising/new-to-you performance issue you have encountered? SQL Server 2019’s slowdowns. I spent days working on that. RoJo: Have you used Distributed AG as a way to upgrade major versions of…

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

Last Updated February 8, 2023

Y’all post and upvote questions at https://pollgab.com/room/brento, and I stream sessions on my Twitch.tv channel where I answer ’em and chat with the audience. 00:00 Start 02:09 Chad Baldwin: Hey Brent! “a friend told me” MSSQL will use an index’s stats to generate a plan, but not use the index itself. 03:25 Jeremiah Daigle: Hey…

The SQL Server Posts You Read the Most in 2022

Last Updated December 26, 2022

Here’s what I wrote in 2022 that gathered the most views: #10: Who’s Hiring in the Database Community? February 2022 Edition – I saw the success of Hacker News’ “Who’s Hiring” monthly posts, and I blatantly stole the idea for the Microsoft data platform community. It works out well, very popular, very popular. #9: PSPO:…

[Video] Office Hours: Holiday Speed Round

Last Updated December 20, 2022

Beep beep! Here’s a speed round of Office Hours where I rip through a dozen questions in under ten minutes. Want to see your own questions answered? Post ’em and upvote the ones you like at https://pollgab.com/room/brento. 00:00 Start 00:22 DB-A-Team: Love and appreciate your work and please don’t make fun of my question. I…

Should You Use SQL Server 2022’s GREATEST and LEAST?

Last Updated December 15, 2022

If you’ve been following along with this week’s posts on DATETRUNC and STRING_SPLIT, you’re probably going to think the answer is no, but bear with me. It’s Christmas week, right? The news can’t all be bad. GREATEST and LEAST are kinda like MAX and MIN, but instead of taking multiple rows as input, they take multiple columns.…

Should You Use SQL Server 2022’s STRING_SPLIT?

Last Updated December 16, 2022

SQL Server 2022 improved the STRING_SPLIT function so that it can now return lists that are guaranteed to be in order. However, that’s the only thing they improved – there’s still a critical performance problem with it. Let’s take the Stack Overflow database, Users table, put in an index on Location, and then test a…

Should You Use SQL Server 2022’s DATETRUNC?

Last Updated December 16, 2022

SQL Server 2022 introduced a new T-SQL element, DATETRUNC, that truncates parts of dates. For example: SELECT DATETRUNC(year, '2017-06-01'); 1 SELECT DATETRUNC(year, '2017-06-01'); Truncates everything in that date other than the year, so it returns just 2017-01-01 00:00: You might ask, “Well, why not just use YEAR()?” That’s a good question – there are times…

Slow “Having” Query? Try Pre-Filtering.

Last Updated November 21, 2022

I was helping a client with a query, and I’m going to rework the example to use the Stack Overflow database for easier storytelling. Say we need to: Find all the locations where users have logged in since a certain date, then Return the total count of people who live in those locations One way…

Join #TeamHugo and Help Fight Leukemia.

Last Updated November 16, 2022

If you’ve been reading this blog for a while or subscribed to my email newsletters, you’ve learned something from Hugo Kornelis. Hugo is the wildly productive and selfless guy behind the Execution Plan Reference, SQLServerFast.com, tons of SQLBits sessions, videos on YouTube, and he’s @Hugo_Kornelis. He’s unbelievably upbeat and positive. He loves what he does, and…

[Video] Office Hours: Sponsored By Black Friday Edition

Last Updated November 10, 2022

Y’all post questions at https://pollgab.com/room/brento, upvote the ones you’d like to see me cover, and then I talk through ’em. Here’s what we covered today: 00:00 Start 00:22 CKI: Could please give me pointers how to answer the question “Do we need to create a new instance for the new application or can use the…

Learn the Fundamentals of TempDB for Free This Week.

Last Updated September 18, 2022

Every weekday during the month of October, one of the modules from my Fundamentals classes will be absolutely free to watch. But you gotta watch it that day – you snooze, you lose. For this week’s TempDB class, you don’t have hands-on labs, but if you want to follow along with the demos, I’ll be using…

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

Last Updated October 20, 2022

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…

4.9 Tuning usp_GetTagsForUser

Last Updated September 30, 2022

A good way to wrap up the class is a simpler query where we can get one good-enough execution plan for everyone:

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.

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

Last Updated September 28, 2022

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…

Buckle Up: October is Free Fundamentals Month!

Last Updated October 7, 2022

How about some completely free SQL Server training? Every weekday during the month of October, one of the modules from my Fundamentals classes will be absolutely free to watch. But you gotta watch it that day – you snooze, you lose. To prep, block out a 30-minute window on your calendar, right now. Put a label…

[Video] Office Hours: Six-Minute Speed Round

Last Updated September 19, 2022

The morning after the Data TLV Summit in Tel Aviv, I stood out on the balcony and answered a few of your questions from https://pollgab.com/room/brento, rapid-fire style: Here’s what we covered: 00:00 Intros 00:47 cyrpl: Hi Brent from PEI, Canada. A support person told me today that when creating a table, an ID column…