Bert Wagner

SQL Server Execution Plan Operators

• by Bert Wagner

• Bert Wagner

Watch this week’s Execution Plan Operators episode on YouTube. SQL Server Execution Plan Operators When examining a query’s execution plan, certain operators tend to crop up over and over...

2019-08-26 (first published: 2019-08-13)

184 reads

5 Things You Need To Know When Reading SQL Server Execution Plans

• by Bert Wagner

• Bert Wagner

Watch this week’s episode on YouTube. 5 Things You Need To Know When Reading SQL Server Execution Plans In the first part of this series I explained what an execution...

2019-08-19 (first published: 2019-08-06)

967 reads

Execution Plans: Statistics

• by Bert Wagner

• Bert Wagner

Watch this week’s Statistics video on YouTube. Last week we looked at what execution plans are and how you can view them. This week I want to discuss what data...

2019-08-12 (first published: 2019-07-30)

516 reads

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

33 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-08-07 (first published: 2019-07-16)

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

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

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

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

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

428 reads