O'Reilly logo

Sams Teach Yourself T-SQL in One Hour a Day by Alison Balter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Lesson 23. Performance Monitoring

It is important you build SQL statements that will execute efficiently. Fortunately SQL Server Management Studio provides you with the tools to analyze your SQL statements and ensure you have built them as efficiently as possible. This lesson introduces you to:

Image How to execute queries in SQL Server Management Studio

Image How to display and analyze the estimated execution plan for a query

Image How to add indexes to allow queries ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required