/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
| | 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.
| | callihandata.com
T-SQL Tuesday 167: Encryption and Data Protection - Chad Callihan
3.6 parsecs away

Travel
| | This month's T-SQL Tuesday topic comes from Matthew McGiffen, who asks us to talk about encryption and protecting data in SQL Server. To read the full topic invite, click the T-SQL Tuesday logo to the right. For this month's invite, I thought I'd write about Transparent Data Encryption (TDE) and give a reminder about how...
| | 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.
| | runswiththedug.wordpress.com
Nepal Photos | runswiththedug
12.6 parsecs away

Travel
| Visit the post for more.