O'Reilly logo

Sams Teach Yourself Microsoft SQL Server 2005 Express in 24 Hours 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

HOUR 24. Performance Monitoring

It is important that you build SQL statements that will execute efficiently. Fortunately, SQL Server Management Studio Express provides you with the tools to analyze your SQL statements and ensure that you have built them as efficiently as possible. In this hour you’ll learn about:

How to execute queries in SQL Server Management Studio Express

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

How to add indexes to allow queries to execute more efficiently

How to set query options

Executing Queries in SQL Server Management Studio Express

SQL Server 2000 provided a tool called the Query Analyzer. This tool is now built into SQL Server Management Studio Express. You can use this tool to ...

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