Introduction to SQL Server Execution Plans

• by Bert Wagner

• Bert Wagner

Watch this week’s episode on YouTube! I nearly always use execution plans as the starting point for SQL query performance troubleshooting. In this multi-part series, I plan to review...

2019-07-23

12 reads

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)

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

246 reads

How I Continuously Learn About SQL Server

• by Bert Wagner

• Bert Wagner

Watch this week’s episode on YouTube. In order to stay current in a technology you have to immerse yourself in community content. Documentation is good for knowing the specification...

2019-07-16

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

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

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

427 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,613 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

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

407 reads