Can’t find the location of Activity Monitor in SQL Server 2008? It’s not under Tools. Open it from the Standard toolbar or by right clicking the server node.
SQL SERVER – 2008 – Optimize for Ad hoc Workloads – Advance Performance Optimization
One time ad hoc plans waste plan cache memory. See how the SQL Server 2008 option optimize for ad hoc workloads keeps them from filling up the cache.
SQL SERVER – AWE (Address Windowing Extensions) Explained in Simple Words
What is AWE? Address Windowing Extensions let 32 bit SQL Server use very large amounts of physical memory. Here it is explained in simple words.
SQL SERVER – Practical SQL Server XML: Part One – Query Plan Cache and Cost of Operations in the Cache
A guest post from Michael Coles, author of Pro SQL Server 2008 XML: a practical XML demo that looks at the query plan cache and the cost of cached operations.
SQL SERVER – Profiler – Adding Filters – Observation on CPU Load
I thought adding a column filter in SQL Server Profiler would lower CPU load. My test with large sample data showed the opposite: the filter raised CPU usage.
SQL SERVER – Difference Between Union vs. Union All – Optimal Performance Comparison
What is the difference between Union vs. Union All? UNION removes duplicates like SELECT DISTINCT, while UNION ALL returns every row. I compare both.
SQL SERVER – My Observation – Effect of Clustered Index over Nonclustered Index
A simpler rewrite of my observation on the effect of clustered index over nonclustered index, with a sample script and execution plans to compare in SSMS.