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
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
Sync Vs Async Statistics? What do you use in your environments? wp.me/p85Be3-h3 #SQLServer #SQLFamily #SQLHelp
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..
Recommend reading this very interesting blog post by @Kendra_Little littlekendra.com/2016/12/08/doe… #SQLServer
Check out my latest blog post 'Trace Flag 4199 Query Optimiser Hotfixes' wp.me/p85Be3-fW #SQLServer #WordPress #QueryOptimiser
Good Morning from Edinburgh, Scotland! Check out my latest blog post "A Guide On Forcing The Legacy CE" #SQLServer wp.me/p85Be3-eP
sqlserverscotsman.wordpress.com
A Guide On Forcing The Legacy CE
Trace Flag 9481 In my previous blog post I showed that when the database compatibility level is 120 or higher, trace flag 9481 can force the query optimiser to use the legacy CE (cardinality estima…
Check out my latest blog post on 'Troubleshooting Query Regressions Caused By The New Cardinality Estimator' wp.me/p85Be3-ci
Understanding The Cardinality Estimator - curatedsql.com/2016/11/16/und… #CuratedSQL
United States 趨勢
- 1. #WorldSeries 195K posts
- 2. Dodgers 238K posts
- 3. Freddie 88.5K posts
- 4. Klein 194K posts
- 5. Ohtani 129K posts
- 6. Kershaw 19.1K posts
- 7. Mookie 15K posts
- 8. Yamamoto 26.6K posts
- 9. #Worlds2025 7,959 posts
- 10. Joe Davis 2,226 posts
- 11. Lauer 5,126 posts
- 12. WHAT A GAME 41.5K posts
- 13. Will Smith 13.8K posts
- 14. 18 INNINGS 12.8K posts
- 15. Marlins 1,860 posts
- 16. Dave Roberts 6,023 posts
- 17. Tommy Edman 4,938 posts
- 18. Bottom of the 18th 2,317 posts
- 19. Schneider 12.6K posts
- 20. Mary Hart N/A
Something went wrong.
Something went wrong.