Search Results for &#8220;sp_blitzindex&#8221;

Brent starts the Lab 1 workload, then steps through a quick SQL Server health check with sp_Blitz, then captures wait stats details with sp_BlitzFirst @ExpertMode = 1, @Seconds = 60. From there, he runs sp_BlitzIndex to check the server’s index designs, and sp_BlitzCache to check which queries were causing the top wait types. He finishes…

You’ll need a membership to access this course. Check out my training classes.

[Video] Office Hours 2017/08/02 (With Transcriptions)

Last Updated August 6, 2017

This week, Brent, Erik, and Richie discuss unit testing, tSQLt, availability groups, duplicate indexes, reporting services 2016 on availability groups, troubleshooting Entity Framework queries, joining views in tables, SQL Server caching issues, and why procedures have plans inside the cache. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or…

Why Missing Index Recommendations Aren’t Perfect

Last Updated August 1, 2017

Brent Ozar

Indexing

Using the good ol’ Stack Overflow public database, get the execution plan for this query – either estimated or actual, doesn’t matter: Transact-SQL SELECT Id FROM dbo.Users WHERE LastAccessDate = '2016/11/10'; 123 SELECT IdFROM dbo.UsersWHERE LastAccessDate = '2016/11/10'; In the execution plan, SQL Server asks for a missing index on the LastAccessDate field: Missing index…

First Responder Kit Release: Yukon Ho!

Last Updated August 1, 2017

First Responder Kit

We’re going to Alaska this month, so try not to find any bugs, okay? To celebrate, I’m channeling childhood nostalgia, and quoting a verse from one of my many Taco-Bell-dripping-stained Calvin and Hobbes tomes. We’ll never have to clean a plate, Of veggie goops and goos Messily we’ll masticate, Using any fork we choose! When…

[Video] Office Hours 2017/07/19 (With Transcriptions)

Last Updated July 23, 2017

This week, Erik and Richie discuss performance tuning, relativity, Always On Availability Groups, parameter sniffing, technical debt, unit testing, deadlocks, testing storage performance, and more… Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our podcast to listen on the go. Enjoy the Podcast? Don’t miss an episode, subscribe…

[Video] Office Hours 2017/07/05 (With Transcriptions)

Last Updated July 11, 2017

This week, Brent and Tara discuss separating data and logs on separate drives, statistics time, scalar UDFs, licensing, encryption, gathering SQL error logs and agent job history, replication, upcoming training courses from Brent Ozar Unlimited, and what DBA topics they struggle with the most. Here’s the video on YouTube: You can register to attend next week’s Office…

First Responder Kit Release: Weather Is Here, Wish You Were Wonderful

Last Updated July 5, 2017

First Responder Kit

ONE TWO THREE FOUR FIVE SIX SEVEN WHO DO WE APPRECIATE? No one. Appreciate doesn’t rhyme with seven. Special thanks to @JohnKNess, @jsetliffe, @rabryst, @gdoddsy and @SOlsonFAC for various levels of contribution. I’ve made a $10,000 donation in each of your names to the Erik Darling Home For Little Wanderers. Very thoughtful of me. You…

[Video] Office Hours 2017/06/14 (With Transcriptions)

Last Updated June 19, 2017

This week, Brent, Erik, Tara, and Richie discuss setting up an archive process, CTEs vs temp tables, deadlocks, alternatives to replication, Erik and Brent’s pre-con for this year’s PASS Summit, and more. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our podcast to listen on the go. Enjoy…

sp_AllNightLog

Last Updated December 13, 2022

Brent Ozar

You manage a SQL Server instance with hundreds or thousands of mission-critical databases. You want to back them all up as quickly as possible, and one maintenance plan job isn’t going to cut it. The basic concept: backing up and restoring databases You also want to protect those databases by restoring them as quickly as…

First Responder Kit Release: Now With 50% MORE Double Checking

Last Updated June 3, 2017

First Responder Kit

So many things happen in mid-Summer. Dreams. Death. Pit stains. And FRK updates! Special thanks to @digitalohm for once again taking the axe to sp_DatabaseRestore. You are the only person on our email list who isn’t getting a Box O’ Tripe® You can download the updated FirstResponderKit.zip here. sp_Blitz Improvements #872 @MosesOfJ pointed out that,…

Bad Idea Jeans: Multiple Index Hints

Last Updated May 23, 2017

Bad Idea Jeans, T-SQL

I hate that you can do this Here’s the thing: I’m mostly writing this because I didn’t know you could do it. But it’s cool, because it’ll reinforce some other concepts, and I’ll show you why you shouldn’t do it. I’m talking, of course, about index hints. To be more specific, hinting multiple indexes on…

First Responder Kit Release: Ça plane pour moi

Last Updated May 1, 2017

First Responder Kit, SQL Server

Ah, May. Spring has sprung, and young people’s minds turn towards seasonal allergies. Special thanks to @digitalohm for the Differential Restore code and general sp_DatabaseRestore spiffiness. May you live to an age that can only be described in Unix. You can download the updated FirstResponderKit.zip here. sp_Blitz Improvements #857 Do you have any idea how much…

[Video] Office Hours 2017/04/26 (With Transcriptions)

Last Updated April 30, 2017

This week, Erik – all by his lonely self – talks about troubleshooting remote queries, his thoughts on SQL Server 2017, licensing, index rebuilds, index fragmentation, why you shouldn’t restart SQL server every day, and much more! Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our podcast to…

SQL Server 2017: Unpublished Gems

Last Updated May 12, 2017

SQL Server 2017

Sneaky, sneaky, sneaky Release notes never seem to tell the full story, do they? At some point, you have to take matters into your own hands and go hunting for, as Paul Harvey would say, “The Rest Of The Story”. So what did I find? New stuff! Brand. New. Stuff. For you. If you ever…

[Video] Office Hours 2017/04/12 (With Transcriptions)

Last Updated April 15, 2017

DISCLAIMER: this week, we learn that a naked Erik Darling looks like a bear covered in squid ink. Thankfully, we don’t learn that via the webcams. Aside from that, Brent, Richie, and Erik also discuss updating stats and rebuilding indexes, feature request for Paste the Plan, included columns’ effect on DML, CLR store procedures, SQL command and…

First Responder Kit Release: Now With 100% More Working Code Than The Irish Space Program

Last Updated April 7, 2017

First Responder Kit, SQL Server

Every April I think about this girl I grew up with named April who smelled like Cheez-Wiz. She died tragically in a home for the blind on Taco Tuesday. Special thanks to @jeffrosenberg , @mrthomsmith , @rwhoward for contributing this month. Your complimentary oxygen is now available. The rest of you can go download the First…

[Video] Office Hours 2017/03/26 (With Transcriptions)

Last Updated April 1, 2017

This week, Erik and Richie discuss truncating log files, reindexing, using sp_rename, query tuning, columnstore indexes, debugging parameter sniffing issues, query processing internals, and troubleshooting query performance issues. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our podcast to listen on the go. Enjoy the Podcast? Don’t miss…

First Responder Kit Release: We hired Brent back because he promised to fix his code

Last Updated March 21, 2017

Humor, SQL Server

March comes in like a 40 of Steel Reserve and leaves like your memory of the night after drinking a 40 of Steel Reserve. Get it here! sp_Blitz Improvements — #758 and #756 We made it less scary to run on Express Edition. Why? Because running Express Edition is scary enough. Coded by @Totty1973 and…

[Video] Office Hours 2017/03/15 (With Transcriptions)

Last Updated March 18, 2017