/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

 littlekendra.com
SQL Server Query Store - Filegroups and Adhoc Workloads
| | erikdarling.com
T-SQL Tuesday: The Last Ticket I Closed - Darling Data
2.3 parsecs away

Travel
| | [AI summary] A SQL Server consultant discusses challenges with foreign key constraints and deadlock issues caused by an eager index spool in a merge operation, leading to the decision to disable the foreign key to improve performance.
| | kendralittle.com
Fixing OPTIMIZATION_REPLAY_FAILED in Query Store: When Plan Forcing Breaks in SQL Server 2022+
0.1 parsecs away

Travel
| | Kendra Little writes and draws comics about SQL Server, Data Platforms, and Database DevOps.
| | dbanuggets.com
Query Store Fundamentals: Query Store Hints - Deepthi Goguri's SQL Server Blog
2.3 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...
| | debthedba.wordpress.com
T-SQL Tuesday #177 - Maintaining Database Code - Deb the DBA
10.9 parsecs away

Travel
| I feel like I've been neglecting my blog this summer so there's nothing like T-SQL Tuesday to help bring me back. A big thanks to Mala Mahadevan (b) for this month's topic, since it is one near and dear to my heart. She asked us how we manage our database code. One of the earliest...