Bert Wagner

Joker’s Wild

This past weekend I had a blast presenting Joker’s Wild with Erin Stellato (blog|twitter), Andy Mallon (blog|twitter), and Drew Furgiuele (blog|twitter). Watch it here! Table of contents: What is...

2019-06-11

7 reads

CHOOSE() in SQL Server

Watch this week’s episode on YouTube. While I know I don’t utilize most of the features available in SQL Server, I like to think I’m at least aware that those features...

2019-06-04

251 reads

Temporary Staging Tables

Watch this week’s episode on YouTube. SQL Server Spool operators are a mixed bag. On one hand, they can negatively impact performance when writing data to disk in tempdb....

2019-05-07

130 reads

IN vs UNION ALL

Watch this week’s episode on YouTube. When you need to filter query results on multiple values, you probably use an IN() statement or multiple predicates separated by ORs: or...

2019-05-13 (first published: )

1,134 reads

Correlated Subqueries vs Derived Tables

Correlated subqueries provide an intuitive syntax for writing queries that return related data. However, they often perform poorly due to needing to execute once for every value they join on....

2019-05-07 (first published: )

1,228 reads

Window Functions vs GROUP BYs

There are many options available for improving the performance of a query: indexes, statistics, configuration settings, etc… However, not all environments allow you to use those features (eg. vendor...

2019-04-25 (first published: )

1,125 reads

Blogs

What is a container anyway?

By

Recently there was a thread on Twitter which established that a lot of IT...

Comparing Execution Plans

By

When you run a query twice, and get dramatically different run times, your first...

What permissions do temp stored procedures use?

By

In a performance tuning class I recently took with Brent Ozar (b/t) he mentioned...

Read the latest Blogs

Forums

Statistics Profile Results

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Statistics Profile Results

Optimize a stored procedure

By keneangbu

I have a stored procedure that is called multiple times to get all the...

Status Update 19 Jun 2019

By Steve Jones - SSC Editor

My apologies. I have completely slacked off here, but since the 17th of May,...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers