Level: Introductory to Intermediate
Sr. Database Administrator
If you have ever gone back and looked at code you wrote in the dark ages of your career, you're likely thinking how you would write it differently now that you have more experience. There are many different types of T-SQL coding mistakes - everyone makes them, but in this session we will talk about how we all can avoid them and write better T-SQL.
You will learn:
- 5 different things to be looking for in poor performing code
- Different methods for gathering performance metrics
- New SQL Server features for troubleshooting query performance