SELECT Expression Execution Order

• by Bert Wagner

• Bert Wagner

Watch this week’s episode on YouTube! Today I want to share with you an interesting observation I made about SELECT expression execution order. I was working on writing a...

2019-07-23 (first published: 2019-07-09)

779 reads

Behind the Scenes: How I Create Weekly Technical Videos

• by Bert Wagner

• Bert Wagner

Be sure to watch this week’s video to get the full behind the scenes experience! Today I want to share my process for blogging and making weekly YouTube videos....

2019-07-19 (first published: 2019-07-02)

343 reads

Multiple Identity Inserts

• by Bert Wagner

• Bert Wagner

Watch this week’s video on YouTube. This week I want to share something that surprised me about using SQL Server’s SET IDENTITY_INSERT statement. I started with two tables with...

2019-07-10 (first published: 2019-06-25)

410 reads

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-07-03 (first published: 2019-06-18)

536 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-25 (first published: 2019-06-11)

436 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)

3,033 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

285 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)

441 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)

768 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,191 reads