2018-08-27
826 reads
Foreign Keys (FK)
2018-06-05
849 reads
2016-08-16
1,315 reads
2016-08-02
1,311 reads
2016-07-05 (first published: 2016-05-26)
708 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,601 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,550 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,850 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,255 reads
Blogs
A Memory-Optimized Roundup – T-SQL Tuesday #117
By Steve Jones
The summary from my fourth T-SQL Tuesday hosting for #117. This time I was...
How do you debug your spark-dotnet app in visual studio?
By Ed Elliott
When you run an application using spark-dotnet, to launch the application you need to...
More PowerShell Remoting coverage in dbatools
By Cludio-Silva
Starting on dbatools version 1.0.31 we introduced better coverage for commands that make use...
Forums
Reading Part of a Dataframe
Comments posted to this topic are about the item Reading Part of a Dataframe
The First Rule
Comments posted to this topic are about the item The First Rule
ColumnStore Indexes not releasing the Deleted Rows
In on table which has CCI columnstore indexes on it, and I run select...
Ask SSC