For Free!
Here’s some stuff I’ve been working on lately:
- Added an inline table valued function that strips characters from a string
- Added a script to create useful Alerts in SQL Server
- Added the recompile_cause column to the
SQL Server Consulting, Education, and Training
Here’s some stuff I’ve been working on lately:
You’ve got a stored procedure that runs slowly, but the problem is that it’s… long. It’s really hard to tell which part is slow, sometimes.
With shorter procs you can probably just collect actual execution plans and …
TOP
queries were missing DESC
for the orderingIf you landed here from Brent’s weekly links, use this link to get my training for 90% off.
The access is for life, but this coupon code isn’t! Get it while it lasts.
Discount applies at checkout, and you …
There are a couple Extended Events that I was really excited about adding to sp_HumanEvents, but try as I might they wouldn’t fire off anything. Ever.
Why was I excited? Because they would tell us why forced parameterization …
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount on to my blog readers if you click from here. I’m also …
I’ve made some changes to my scripts! Exciting. Sorta. Kinda.
Got a name change. The code hasn’t changed at all. I started getting annoyed by the formatting and the underscore between pressure and detector.
Now …
There are a lot of words you can use to describe Extended Events. I’ll skip over my list to keep the blog family friendly.
In this post, we’re going to look at how two event can …
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount on to my blog readers if you click from here. …
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount on to my blog readers if you click from here. I’m also available for …