SQLScotsman's profile picture. Production SQL Server DBA

SQL Scotsman

@SQLScotsman

Production SQL Server DBA

SQL Fam - Does anyone know or can explain the engine behaviour when deleting/updating lob data from a heap? Full question here: stackoverflow.com/questions/4961… #SQLSERVER #SQLInternals #SQLFamily #SQLHelp


Thanks to @SQLRich for what was to me the best session of the week so far! #InvestigateTempDBLikeSherlockHolmes #SQLbits #SQLbits2018


Great Q&A session with the legends @SQLConor, @sqlpto, @bobwardms & @S_u_n_e_e_l to finish off a training day at the Microsoft Reading Campus #Microsoft #SQLServer


Excited for tomorrows SQL Server User Group in Glasgow #SQLGLA with some sessions from @sql_williamd & @clat to look forward to! #SQLServer #SQLFamily


SQL Scotsman 已轉發

Updating Multiple Statistics Concurrently - curatedsql.com/2016/12/22/upd… #CuratedSQL


Re-Watching this classic: 'Inside The SQL Server Query Optimiser' By @TexasConor sqlbits.com/sessions/event…


Giving @closedasfixed a follow as recommended by @MatanYungman in Episode 59 of #SQLServerRadio Very cool twitter account, a must follow!


Ever wonder what locks are taken by update statistics operations? Then this blog post is for you: wp.me/p85Be3-jF #SQLServer #Blog


Check out my latest blog post: "Update Multiple Statistics On The Same Table Concurrently – Locks & Trace Flag 7471" wp.me/p85Be3-jF


#ReadyPlayerOne By @ErnestCline is the best book I've read in 2016, by far! Got it from @PaulRandal recommended reading list, thanks Paul!


Check out my latest blog post: "Statistics - Single Threaded & Parallel Operations" wp.me/p85Be3-hu #SQLFamily #SQLServer #Blogger


Downloaded the latest @sqldatapartners podcasts for the long drive through to Edinburgh tomorrow! #SQLServer #PodCast #GoodListening


Has anyone ever seen automatically created column stats interfering with index stats on the same column? #SQLHelp #SQLServer #SQLFamily


Check out my latest blog post 'Sync Vs Async Statistics: The Old Debate' at wp.me/p85Be3-h3 Would be good to know others thoughts..


Check out my latest blog post on 'Troubleshooting Query Regressions Caused By The New Cardinality Estimator' wp.me/p85Be3-ci


SQL Scotsman 已轉發

Understanding The Cardinality Estimator - curatedsql.com/2016/11/16/und… #CuratedSQL


United States 趨勢

Loading...

Something went wrong.


Something went wrong.