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
sqlserverscotsman.wordpress.com
Sync Vs Async Statistics: The Old Debate
Statistic objects in SQL Server are light-weight objects containing statistical information about the distribution of values in one or more columns. Statistics are used to calculate cardinality es…
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..
sqlserverscotsman.wordpress.com
Sync Vs Async Statistics: The Old Debate
Statistic objects in SQL Server are light-weight objects containing statistical information about the distribution of values in one or more columns. Statistics are used to calculate cardinality es…
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. Cowboys 63.7K posts
 - 2. Cardinals 28.1K posts
 - 3. #WWERaw 56.6K posts
 - 4. Jerry 43.7K posts
 - 5. Logan Paul 9,223 posts
 - 6. Kyler 7,447 posts
 - 7. Jacoby Brissett 4,525 posts
 - 8. Koa Peat 5,735 posts
 - 9. Pickens 6,361 posts
 - 10. Javonte 3,785 posts
 - 11. Bland 11.5K posts
 - 12. Cuomo 160K posts
 - 13. Walter Nolen 1,571 posts
 - 14. Dak Prescott 4,383 posts
 - 15. Calais Campbell N/A
 - 16. Pacers 10.8K posts
 - 17. #MondayNightFootball 1,298 posts
 - 18. Steele 5,973 posts
 - 19. Eberflus 1,997 posts
 - 20. Nick Smith Jr N/A
 
Вам может понравиться
Something went wrong.
Something went wrong.