Search Results for “first responder kit”

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

Computed Columns Referencing Functions

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

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)

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

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

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
Menu