Subscribe to this blog
Archives: November 2010
Recompiles
I’ve looked at cache hit and miss events and at the cache insert and remove events. The only cache-monitoring event (of current interest) left is the recompile event.
There are two recompile events available in Profiler in SQL 2008
- SP:Recompile under Stored Procedures
- SQL:StmtRecompile under T-SQL
Which to use when? Read more
0 comments, 378 reads
Posted in SQL In The Wild on 18 November 2010
First Impressions
SELECT @@Version
Microsoft SQL Server “Denali” (CTP1) – 11.0.1103.9 (X64)
I’ve been playing with the CTP for a few days (with absolutely no documentation) and there are a few fun and interesting things that I found. These may not be earth-shattering changes, but they are interesting, and I don’t doubt… Read more
1 comments, 267 reads
Posted in SQL In The Wild on 9 November 2010