/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

 matthewmcgiffen.com
Avoid "Constants" in T-SQL - Matthew McGiffen Data
| | blog.sqlterritory.com
Foreign Keys and Index Usage Stats - SQLTerritory.com
3.4 parsecs away

Travel
| | In this post, I'm checking if Foreign Key constraints check does updates index usage statistics DMV. I also provide quick demo code I used for my test.
| | erikdarling.com
T-SQL Tuesday: The Last Ticket I Closed - Darling Data
4.2 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.
| | nocolumnname.blog
SQL Server is messing with my Identity - No Column Name
4.3 parsecs away

Travel
| | When working with SQL Server, you are going to be using TempDB; that is a certainty. Using temporary tables, however, isn't a certainty. I'm taking it for granted that at one time or another you have used them but it's not something I can say forcertain. ...if you aren't using temporary tables AT ALL, please...
| | curatedsql.com
Fabric Studio 1.0 - Curated SQL
13.2 parsecs away

Travel
| [AI summary] The blog post announces the release of Fabric Studio 1.0, a VSCode extension for managing and developing Fabric workspaces, highlighting its integration with VSCode and available features.