Product has been added to your cart.

Search Results for “first responder kit”

  1. Home
  3. Search Results
    4. (Page 18)

Computed Columns Referencing Functions

Erik Darling
Computed Columns Referencing Functions If you’re here, it’s likely because sp_BlitzCache found a computed column referencing a scalar UDF. For more information about why this is bad, check out a couple blog posts: Still Serial After All These Years Another reason why scalar functions in computed columns is a bad idea And a video!
Read More

Optimizer Forcing

Erik Darling
Some hints can harm performance If you’re here, it’s most likely because sp_BlitzCache warned you about index or seek/scan forcing. Index forcing Index forcing has some pretty harmful side effects. Aside from the fact that it will stop SQL from making missing index requests, your queries will start to fail if the index gets disabled…
Read More

[Video] Office Hours 2016/08/31 (With Transcriptions)

Brent Ozar Unlimited Team
SQL Server, Videos
3 Comments
This week, Brent, Richie, and Tara discuss corruption, resetting query stats, fixing parameter sniffing issues, how to suggest features for our scripts, and why Brent is sporting an Oracle sweatshirt. 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?…
Read More
Pocket Square

Database Settings Changed Away from Defaults

Brent Ozar
Blitz Result: Database Settings Changed Away from Defaults SQL Server has a lot of knobs and buttons, and us human beings just love pushing buttons and tweaking knobs. SQL Server needs a dog to prevent us from touching ’em. This portion of sp_Blitz® checks sys.databases looking for settings that have been changed away from their defaults.…
Read More
Pocket Square

sp_BlitzTrace™: Extended Events Traces Made Easy

Kendra Little

sp_BlitzTrace Ever wanted to quickly and easily record how much CPU a query is using, how many logical reads it uses, what temporary objects are created, and whether it causes a recompile? sp_BlitzTrace is a free stored procedure that helps you quickly and easily use Extended Events in SQL Server 2012 and higher to observe…

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

Hi! I’m Brent Ozar.

I make Microsoft SQL Server go faster. I love teaching, travel, cars, and laughing. San Diego, California. He/him. I teach SQL Server training classes, or if you haven’t got time for the pain, I’m available for consulting too.

Want to advertise here and reach my savvy readers?

Menu