Jeff Moden's Linkedin Analytics

Microsoft SQL Server Senior Database Administrator, database designer/architect, T-SQL programmer, high performance code/ETL, database and T-SQL tuning, Instructor, and Mentor. Specialties: Microsoft SQL Server, T-SQL, stored procedures, functions, views, triggers, ETL, performance tuning, set based programming, mentor, and System DBA. Have converted many 24 hour jobs to run in less than 15 minutes and 8 hour jobs to run in seconds. Replaced CLR audit triggers that took 4 minutes to audit 5 column updates on only 10,000 rows to sub-second times using special techniques to build T-SQL-only triggers. 9 year Microsoft SQL Server MVP and winner of Red Gate's Exceptional DBA Award for 2011. Recently destroyed the myths of Random GUID Fragmentation and supposed "Best Practices" for index maintenance that have been wrong for more than 2 decades.