Also, check for expensive operations such as ... to guide SQL Server towards a more consistently efficient execution plan. SQL Server caches execution plans to save time on future query executions.

One of my friend asked me whether is it possible in SQL Server 2005/2008 to know how a query is executing ... Or press [Ctrl+M] for Include Actual Execution Plan and [Shift+Alt+S] for Include Client ...

Here are three examples: DBCC CHECKALLOC — Check disk allocation consistency ... running a query and capturing the execution plan event in a SQL Server Profiler trace. What does the SQL Server ...