/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

sqlservercode.blogspot.com
| | erikdarling.com

[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.
2.2 parsecs

Travel
| |
| | hemantoracledba.blogspot.com

An Oracle Database DBA (Database Administration) Blog.
3.0 parsecs

Travel
| |
| | curatedsql.com

[AI summary] The article discusses the new PRODUCT() function in SQL Server 2025, which multiplies values in datasets rather than adding them, similar to other functions but with distinct operations.
2.0 parsecs

Travel
| |
| | sqlkover.com

It's #TSQL2sday time! This month's invitation has been sent out by Brent Ozar and he asks us to describe the most recent issue - or the last ticket - we closed. In my case, I actually blogged about it in this blog post: Azure Function App doesn't retrieve most recent secret value from Azure Key
12.4 parsecs

Travel
|