Every Twitter/x post I see is a question. Nobody just says what’s on their mind. Only people with good content seem to do that. If the post starts with what/how/who/why I scroll on now.
New blog post on synchronous stats updates: blog.sqlgrease.com/statman-querie…
blog.sqlgrease.com
STATMAN queries causing you timeouts? - SQLGrease SQL Server Performance tips
If you see statman queries showing up they can be causing you slowness with synchronous statistics updates. This post shows what to look for and how to enable asynchronous statistics updates.
If you use sys.dm_exec_requests or sysprocesses to look at sessions this post explains what the status column means:blog.sqlgrease.com/what-does-the-…
blog.sqlgrease.com
What does the status column of a session mean in SQL Server? - SQLGrease SQL Server Performance tips
You might notice there is a status column when you look at active executing requests in either sys.dm_exec_requests, sys.dm_exec_sessions, or sysprocesses. The status column indicates a general...
Announcing that @SQLGrease is now a Silver Level Sponsor for #SQLSatJax on May 4th, 2024. Thank you! #SQLSatJax1068 @sqlsatofficial sqlsaturday.com/jax sqlgrease.com
Ever have a performance problem due to a hint someone added and you need to remove it without changing code? blog.sqlgrease.com/removing-a-tab…
blog.sqlgrease.com
Removing a table hint without changing code - SQLGrease SQL Server Performance tips
On occasion I’ll run into a production performance problem where hints were added to a query and the hint is having a negative effect on performance. In some cases this is the result of something...
New blog post on adding hints to a query with query store. Spoiler alert, some hint types aren't supported: blog.sqlgrease.com/adding-hints-t…
blog.sqlgrease.com
Adding hints to queries with query store - SQLGrease SQL Server Performance tips
With SQL Server 2022, Azure SQL Database, or Azure Managed Instances you can now add hints to queries via Query Store.
SSMS tips: Today's lifesaver Cycle Through Your Clipboard History In SSMS Ctrl+Shift+V
Tuesday Roundtable youtube.com/watch?v=-v-ppq… Content by @zimmergren @SQLGrease @LuchoPorPista @Alex_TheAnalyst @ElizabethOldag @j0hnnyw1nter @MrAndyCutler @DataMozart @hellosqlkitty @JoshLuedeman @SQLBalls @nodestreamIo @DBABullDog @neeraj_jhaveri
Post on forcing plans for non parameterized SQL: blog.sqlgrease.com/query-store-an…
blog.sqlgrease.com
Query store and plan guides for non parameterized SQL - SQLGrease SQL Server Performance tips
forcing plans on non parameterized sql
Thank you so much to the @sqlsatboston team. You guys put on a great event. #sqlsatboston
It was a success!! Thank you to all speakers, volunteers, sponsors, attendees. Organizing this event with the best volunteer team in the world was an honor. See you next year. #sqlsatBoston
Wrapping up deploying a new feature which detects and helps diagnose unsargable predicates. Just in time for the new year!
Thanks to @sqlgrease for sponsoring SQL Saturday Denver 2022. Register to come in person on Sep 17 at sqlsaturday.com/denver You can watch Migrating to Azure SQL Database and learn about the PaaS service first thing in the morning
If you've ever run into negative session IDs this will explain why: blog.sqlgrease.com/negative-block…
10 days left #SQLSatJax!! @unfComputing @SNICompanies @CozyRoc @Tintri @FultonAnalytics @PureStorage @onecallcm @ProCureSQL @dbWatch @SQLGrease @mssqltips @OReillyMedia @datavail @SIOSTech @Quest @OctopusDeploy @PavilionData @redgate @heimdalldata @Microsoft @Idera_Software
Two new posts regarding tuning queries that are looking for the first X number of characters or last X number of characters: blog.sqlgrease.com/improving-perf… blog.sqlgrease.com/improving-perf…
United States 趨勢
- 1. George Santos 29.3K posts
- 2. Louisville 7,384 posts
- 3. Dan Wilson 1,399 posts
- 4. #askdave N/A
- 5. Jeff Brohm N/A
- 6. Bryce Miller 1,553 posts
- 7. Tina Peters 5,410 posts
- 8. Chris Bell N/A
- 9. Prince Andrew 46.4K posts
- 10. No Kings 310K posts
- 11. End 1Q N/A
- 12. End of 1 14.1K posts
- 13. Brash N/A
- 14. Malachi Toney N/A
- 15. #DaytimeEmmys 1,103 posts
- 16. Gio Ruggiero N/A
- 17. Duke of York 19K posts
- 18. #LightningStrikes N/A
- 19. #drwfirstgoal N/A
- 20. Miller Moss N/A
Something went wrong.
Something went wrong.