SQL Scotsman
@SQLScotsman
Production SQL Server DBA
Vous pourriez aimer
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
Check out my latest blog post on 'Troubleshooting Query Regressions Caused By The New Cardinality Estimator' wp.me/p85Be3-ci
sqlserverscotsman.wordpress.com
Troubleshooting Query Regressions Caused By The New Cardinality Estimator
In this blog post I’ll show methods that can be used to identify and troubleshoot query plan regressions caused by the new cardinality estimator. I’ll show how this was a very manual task in SQL S…
Understanding The Cardinality Estimator - curatedsql.com/2016/11/16/und… #CuratedSQL
United States Tendances
- 1. VMIN 25K posts
- 2. Good Saturday 20.4K posts
- 3. #SaturdayVibes 3,192 posts
- 4. Nigeria 466K posts
- 5. #LoVeMeAgain 35.2K posts
- 6. Chovy 13K posts
- 7. seokjin 235K posts
- 8. VOCAL KING TAEHYUNG 37.7K posts
- 9. New Month 302K posts
- 10. Social Security 45.1K posts
- 11. #SaturdayMotivation 1,121 posts
- 12. Spring Day 56.9K posts
- 13. Merry Christmas 11.7K posts
- 14. GenG 6,601 posts
- 15. #saturdaymorning 1,466 posts
- 16. #GrandEgyptianMuseum 27K posts
- 17. IT'S GAMEDAY 1,450 posts
- 18. Game 7 79.4K posts
- 19. Shirley Temple 1,156 posts
- 20. Go Bucks N/A
Vous pourriez aimer
Something went wrong.
Something went wrong.