2018-08-27
825 reads
Foreign Keys (FK)
2018-06-05
847 reads
2016-08-16
1,315 reads
2016-08-02
1,310 reads
2016-07-05 (first published: 2016-05-26)
706 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)
4,523 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,523 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)
3,709 reads
2015-10-07
1,374 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,239 reads
Blogs
The Microsoft Power Platform
By James-Serra
The Microsoft Power Platform consists of three products: Power BI, PowerApps, and Microsoft Flow....
From Evangelist to Advocate
It’s time for a little bit of change to occur. I am no longer...
Database File Changes
Data professionals around the globe are frequently finding themselves occupied with figuring out why...
Forums
Building a table based on another one(s)
Hi, We have 3 people that answer the phones to help our customer with...
Best way to find if string is whitespace
I appreciate it is a trifling question and yet. One of our sites organises...
How to measure Latency between App and database server
Hi All, We have SQL Server instance running on a VM. Now we wanted...
Ask SSC