Easy way to read XML execution plans.
A great way to easily read the XML execution plan that SQL can produce.
New tip published about table statistics
My next tip on SQL Server Statistics has been published on SearchSQLServer.com entitled Update SQL Server table statistics for performance kick.
Upgrade for sp_who2 called sp_who3
I’ve published this before over on tek-tips.com, but I figured that I’d republish it here as well. I’ve written an update for sp_who2 which I call sp_who3. It can be most useful when trying to diagnose slow running queries as it can provide a wealth of information in a single screen.
How SQL decides how much procedure cache and how much buffer cache to use.
There are two main types of cache which SQL Server deals with, the buffer cache and the procedure cache. The procedure cache is where the execution plans for procedures and queries are storred. The buffer cache is where the actual data is cached so that SQL Server doesn’t have to go to disk to get often accessed data.