Most RecentMost ViewedMost LikesCreate a Quick and Easy Performance Baseline First published on MSDN on Oct 11, 2016 In this blog post I am going to discuss a very little-known performance metric introduced in SQL Server 2012 that you can use to instantly get a baseline of the query performance for your system. Where is a record really located? First published on MSDN on Sep 15, 2016 Recently I had a question regarding "What happens to records when they are deleted" – so I wanted to dig into what happens under the covers when just such a thing happens.