Tag Archives: SQL Server Engine

Execution Plan of Frequent Queries

Posted on May 29, 2009 by Clay Lenhart

Bill Galashan, DBA of bet365 sent over the following query that lists the execution plan of the 10 most frequently executed queries. Continue reading →

Posted in SQL Server Administration | Tagged , , , , , | Leave a comment

Influencing the Execution Plan

Posted on April 14, 2008 by Clay Lenhart

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 , , | 1 Comment

Cached Execution Plans in SQL Server

Posted on April 13, 2008 by Clay Lenhart

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 , , , , , , | 1 Comment

Table Size Query

Posted on March 8, 2008 by Clay Lenhart

The following query lists the tables and the space they use. This query is much faster (sub-second) than a standard SELECT COUNT(*) query since it uses the dynamic management views in SQL Server rather than scanning your data. SELECT sum … Continue reading →

Posted in SQL Server Administration | Tagged , | 2 Comments