SQLGrease
@SQLGrease
We build performance monitoring software for SQL Server.
You might like
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 Trends
- 1. #wednesdaymotivation 7,752 posts
- 2. Gold Glove 2,981 posts
- 3. Jay Jones 62.8K posts
- 4. #LoveYourW2025 287K posts
- 5. Good Wednesday 34K posts
- 6. Young Republicans 117K posts
- 7. Vision Pro 4,090 posts
- 8. Christen Press 3,232 posts
- 9. Talus Labs 14.4K posts
- 10. #Wednesdayvibe 2,091 posts
- 11. Alan Jackson N/A
- 12. Hump Day 17.2K posts
- 13. Bessent 66.6K posts
- 14. Markey 1,660 posts
- 15. Voting Rights Act 12.1K posts
- 16. Moulton 1,036 posts
- 17. Riggs 1,048 posts
- 18. Tami 5,868 posts
- 19. #GenV 6,088 posts
- 20. Leto 8,019 posts
Something went wrong.
Something went wrong.