SQL Server Quick Tips

• by Bert Wagner

• Bert Wagner

Earlier this year I made a series of videos that were played before the start of several DBA Fundamentals presentations. These videos gave viewers something SQL related to watch while the...

2019-09-17

24 reads

Whitespace, Letter Case, and Other Things That Prevent Plan Reuse

• by Bert Wagner

• Bert Wagner

Watch this week’s episode on YouTube. Last week’s post briefly mentioned that SQL server may not reuse a query plan from cache if there is a small difference in whitespace....

2019-09-16 (first published: 2019-09-03)

383 reads

How I Troubleshoot SQL Server Execution Plans

• by Bert Wagner

• Bert Wagner

Watch this week’s video on YouTube. Today I’m concluding my series on SQL Server execution plans by sharing the specific steps I take when troubleshooting a slow performing query....

2019-09-12 (first published: 2019-08-27)

1,176 reads

Tracking Who Last Changed a Row

• by Bert Wagner

• Bert Wagner

This post is a response to this month’s T-SQL Tuesday #118 prompt by Kevin Chant.  T-SQL Tuesday is a way for the SQL Server community to share ideas about different database and professional...

2019-09-10

128 reads

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)

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

1,091 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)

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

921 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

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

755 reads