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:
How to execute queries in SQL Server Management Studio
How to display and analyze the estimated execution plan for a query
How to add indexes to allow queries ...
Get Sams Teach Yourself T-SQL in One Hour a Day now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.