Are Stored Procedures Faster Than Stand-Alone Queries?

• by Bert Wagner

• Bert Wagner

Watch this week’s episode on YouTube. A few months ago I was presenting for a user group when someone asked the following question: Does a query embedded in a...

2019-10-15

31 reads

Communicating Effectively at the Workplace

• by Bert Wagner

• Bert Wagner

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

2019-10-10 (first published: 2019-10-08)

357 reads

More “Wrong” SQL Server Math – Floating Point Errors

• by Bert Wagner

• Bert Wagner

Watch this week’s episode on YouTube. Last week we looked at how implicit conversions and datatype precedence can cause SQL Server to output unexpected results (if you aren’t aware of how...

2019-10-01

113 reads

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-24 (first published: 2019-09-17)

805 reads

SQL Server’s “Wrong” Math

• by Bert Wagner

• Bert Wagner

Watch this week’s video on YouTube! A couple of weeks ago I decided to rebuild my recording studio by getting rid of my fabric backdrop and replacing it with...

2019-09-24

42 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-19 (first published: 2019-09-10)

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

456 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,429 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)

795 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,132 reads