Tag Archives: performance

Influencing the Execution Plan

I had a performance problem recently with SQL Server. This post shows an easy relatively hands-off approach to influencing the execution plan. Continue reading

Posted in SQL Server Development | Tagged , , | 10 Comments

Cached Execution Plans in SQL Server

This blog entry describes how you can get the SQL Server execution plan of any running statement and display the graphical representation in Enterprise Manager. Continue reading

Posted in SQL Server Administration | Tagged , , , , , , | 37 Comments