/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

 www.scarydba.com
Monitor Cardinality Feedback in SQL Server 2022 - Grant Fritchey
| | dbanuggets.com
Query Store Fundamentals: Query Store Hints - Deepthi Goguri's SQL Server Blog
0.9 parsecs away

Travel
| | Source: Image Query Store hints is another amazing feature added and is available in the preview mode in Azure SQL Database, managed instances, elastic pools and hyperscale databases as well. Query Store hints are just like the hints you use in your queries but the difference is you do not have to change the query...
| | www.sqlserver-dba.com
Extended Events to capture Blocking
0.9 parsecs away

Travel
| | SQL Server blocking query history
| | sql-sasquatch.blogspot.com
sql.sasquatch: SQL Server Query Store: Usability Soft Spots -- Part 2
1.3 parsecs away

Travel
| | Part 2 Summary: the stored procedure was modified to no longer use "SELECT... INTO" with a table from tempdb, and to truncate the results t...
| | blobeater.blog
SQL Server - max server memory | All About Tech
14.8 parsecs away

Travel
| Another re-post of a video from last year, this time showing you an in-built protection of setting max server memory for your SQL Server. You can clearly see that if you enter a silly figure such as 50 MB, the minimum memory amount allowable for max server memory is 128 MB. You will see SSMS...