Discovering the differences in releases
I know I'm a Geek @ heart and I do get that "Ooooh" moment when I find something different in a release (and I haven't just read it in a blog, book or another source)
One such moment occured last week, I'm in a Study group fro the MCM on Yammer ( https://www.yammer.com/sqlmcmstudygroup )
One of our Members: Matin Carins {who is a newly minted MCM @ that} Posted a question that got a lot of responses, I thankfully even managed to answer the question correctly 
, it was to do with unshrinkable Trans logs .. answer is available in the thread if your intrested
Anyway my post here is that we used fn_dblog to review the contents of the Trans log and I tried the example Script that Martin posted up and ran this on a SQL 2008R2 and also my 2012 RC0 builds
The results clearly showed some speed improvements when run on 2012 RC0 
(but this wasn't the main highlight for me .. that was that output of the fn_dblog)
The screen shot below shows the excact same Query that was run on the 2 builds.. both created a new database and inserted some dummy data to do the backup & Trans log shrink tests
Results on the LEFT are for the 2012 RC0 build (11.0.1750) and the results on the RIGHT are for the 2008 R2 Build (10.50.2500)
Noticed we have a new Column RecoveryUnitID (I haven't explored this one yet.. but will do so)
and also the query that provide the breakdown of operations has many more results {again intresting to investigate @ a later datetime when I have some spare time)
And finally the 2012 RC0 has less used pages (216 vs 256) and less active VLFs - so again this looks worthy of further investigations
Below are segments of the script that provided these results
DBCC SHRINKFILE(ActiveVLFDemo_Log,1,TRUNCATEONLY)
DBCC LOGINFO
SELECT Operation,COUNT(*) FROM fn_dblog(NULL,NULL)
GROUP BY
Operation HAVING
COUNT(*) > 1
ORDER BY
COUNT(*) DESC
