11 Steps to upgrade SQL Server 2012 RTM Evaluation Edition to a licensed edtion.
Three ways of determining SQL Server 2012 Evaluation Period Expiry Date
SQL_Batching_Methods_Comparison_Chart
Performance of the new Paging Function in SQL Server 2012 compared to other batching/paging methods
SQL Server 2012
So you've heard SQL Server 2012 release is coming very soon, with its Virtual Launch Event on 7 March 2012. Have you tried SQL Server 2012 RC0 yet?
Filtered Index feature has been introduced since SQL Server 2008. In my recent survey with some […]
See you in Seattle [PASS Summit 2011]
I have recently co-presented with Victor Isakov (from SQL Server Solutions) at the Sydney SQL Server User Group on "Important Trace Flag that Every Expert DBA Should Know. The presentation went quite well and I learnt more things that I could imagine from co-presenting.
Using CTE To Remove Duplicate Records
I have been asked a few times on what is the best way to remove duplicate […]