Paul S. Randal
I was on the SQL team for almost 9 nine years - wrote a bunch of DBCC commands (e.g. INDEXDEFRAG, SHOWCONTIG, CHECKDB/repair), ran the Access Methods development team for SQL Server 2005, and ended up being responsible for the entire Core Storage Engine for SQL 2008. Occasionally I have to resort to "I'm sorry, you are incorrect, the code does not do that", which I hate, as in https://imgur.com/gallery/8t74s.
I'm an expert on Storage Engine internals, wait statistics, HA, maintenance, and disaster recovery. I teach this stuff internally for Microsoft and at conferences/clients around the world.
The answer usually starts with 'it depends'! :-)
Member for 10 years, 6 months
245 profile views
Last seen Nov 24 '19 at 20:21