2018-08-27
837 reads
Foreign Keys (FK)
2018-06-05
856 reads
2016-08-16
1,320 reads
2016-08-02
1,335 reads
2016-07-05 (first published: 2016-05-26)
1,898 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)
6,388 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)
5,611 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)
5,043 reads
2015-10-07
1,377 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)
15,044 reads
Blogs
How to Change the Browser Used by SSMS for AAD Auth
Did you know that you can change the browser used by SQL Server Management...
Typing with Your Tongue Part 2: Voice Access
By DataOnWheels
A few months ago, I wrote a post on how I use voice technology...
Tales From The Field Weekly Wrap Up for the Week of 03-20-2023 & Kiddos Growing Up
By SQLBalls
William, right, 11 years ago the morning of our college tour Hello Dear Reader! When...
Forums
Being Responsible for Data
Comments posted to this topic are about the item Being Responsible for Data
Contained Availability Groups
Comments posted to this topic are about the item Contained Availability Groups
creating a copy of database with an ndf file
I need to send a copy of this to our customer but do not...
Ask SSC