usp_SQLServerCarpenter_Tools_Get_Procedures_Triggers_Missing_SET_NOCOUNT_ON

This procedure will get all the stored procedures and triggers missing the use of SET NOCOUNT ON. It may be helpful in performance tuning assignments.

A New MVP Led Training Initiative – Cloud Formations

Hello Readers – I wanted to make sure those who follow my blog have heard about the new MVP led training initiative started by Paul Andrew (@mrpaulandrew). It’s called...

Scary Scalar Functions - Part Two: Performance

Scary Scalar Functions series overview

Part One: Parallelism
Part Two: Performance

Foreword
In the second part of this series, we’ll look at how Scalar functions (or UDFs) affect performance.
If you want to follow...

Goal Progress for June 2022

I set goals at the beginning of the year, and I’m tracking my progress in these updates during 2022. Ugh, June was no bueno for life goals. In May,...

Using Sessionize for Your User Group – Part 2

Now that your CFS has been setup it’s time to get the word out first. There are many ways to this. I start with using the Cfs secret page...

Daily Coping 1 Jul 2022

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

Updates from Coping Tips

I’ve written a lot of coping tips now. Over two years worth (Mon-Fri) since the pandemic began. It’s become an interesting thing to do on a regular basis, making...

What I’ve learned in my first 100 days with a consulting group

In case you don’t follow me on LinkedIn or Twitter, your humble host joined the smart folks at Straight Path Solutions in March. This is a talented group of...

Power BI as a enterprise data warehouse solution?

With Power BI continuing to get many great new features, including the latest in Datamarts (see my blog Power BI Datamarts), I’m starting to hear customers ask “Can I...

Daily Coping 30 Jun 2022

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...