Bert Wagner

Trailing Spaces in SQL Server

• by Bert Wagner

• Bert Wagner

Watch this week’s episode on YouTube. A long time ago I built an application that captured user input. One feature of the application was to compare the user’s input...

2019-06-18

12 reads

Joker’s Wild

• by Bert Wagner

• Bert Wagner

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

• by Bert Wagner

• Bert Wagner

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

12 Ways To Rewrite SQL Queries for Better Performance

• by Bert Wagner

• Bert Wagner

Watch this week’s video on YouTube. Thanks to you, we just crossed the 2k subscriber mark! Over the past several week’s I’ve been exploring ways to rewrite queries to improve...

2019-06-13 (first published: 2019-05-28)

2,213 reads

Predicate Execution Order on Mixed Data Type Columns

• by Bert Wagner

• Bert Wagner

Watch this week’s episode on YouTube. SQL Server’s cost-based query optimizer does a pretty good job of figuring out what order to filter your data to get fast query...

2019-06-04 (first published: 2019-05-21)

387 reads

Animating a Magic 8 Ball in SQL Server Management Studio

• by Bert Wagner

• Bert Wagner

This post is a response to this month’s T-SQL Tuesday #114 prompt by Matthew McGiffen.  T-SQL Tuesday is a way for the SQL Server community to share ideas about different database...

2019-05-24 (first published: 2019-05-14)

665 reads

Temporary Staging Tables

• by Bert Wagner

• Bert Wagner

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

• by Bert Wagner

• Bert Wagner

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: 2019-04-30)

1,134 reads

Correlated Subqueries vs Derived Tables

• by Bert Wagner

• Bert Wagner

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: 2019-04-23)

1,228 reads

Window Functions vs GROUP BYs

• by Bert Wagner

• Bert Wagner

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: 2019-04-16)

1,125 reads