2018-08-27
830 reads
Foreign Keys (FK)
2018-06-05
852 reads
2016-08-16
1,316 reads
2016-08-02
1,317 reads
2016-07-05 (first published: 2016-05-26)
722 reads
Trust, or Verify – How FKs Can (or Cannot) Help Performance
Learn how trusted foreign keys (FK) can help or hurt performance.
2018-08-24 (first published: 2016-03-08)
5,262 reads
Foreign Key Indexes and Binding
Understand what FK's do and how they use indexes. Then use my script to see if they're using good indexes.
2018-06-29 (first published: 2016-02-10)
4,806 reads
Auto-suggesting foreign keys and data model archaeology
If you can understand the data model then you can understand the intent of the application developers.
2018-07-06 (first published: 2016-01-26)
4,278 reads
2015-10-07
1,376 reads
Indexing Foreign Keys
Foreign Keys are one of the fundamental characteristics of relational databases and enforce the referential integrity. Is it a good idea to index a FK relationship? When can it help?
2016-09-16 (first published: 2015-06-29)
13,757 reads
Blogs
Your First Databricks Notebook
By DataOnWheels
On August 4, 2020, I presented this on the weekly Pragmatic Works webinar series....
SQL Clone Works with FILESTREAM
By Steve Jones
SQL Clone is an amazing product that virtualizes your data, allowing multiple instances to...
Fun and profit with UTF-8
When SQL Server 2019 was announced, it brought with it UTF-8 support. Also available...
Forums
Removing TDE from a Database: Level 4 Stairway to TDE
Comments posted to this topic are about the item Removing TDE from a Database:...
SQL Deadlock
I have Simple SP to Insert Single Record from Application. When I executes it...
Connecting and working with SQL server in SSMS without WMI is extremely slow.
Hi All, I have a slightly weird situation; on one PC that is domain...
Ask SSC