2018-08-27
829 reads
Foreign Keys (FK)
2018-06-05
851 reads
2016-08-16
1,315 reads
2016-08-02
1,316 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)
4,923 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,698 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,121 reads
2015-10-07
1,375 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,429 reads
Blogs
Join me at SQLBits 2020
The SQLBits conference is taking place in London again this year, between March 31st...
DBA, a job, a vital job
DBA, a job, a vital job. T-SQL a language that is fun. Select, a...
SOS_SCHEDULER_YIELD – What is it really telling us?
I decided to write this off the back of a conversation I was having...
Forums
SMO Certificate Export - FailedOperationException
Greetings, Given this Powershell SMO method call... $_cert.Export("$CertificateLocation\$_cert_name.cer", ` "$PrivateKeyLocation\$_cert_name.pvk", ` $_secret) where $_cert...
Resultset in a format
I have the following tables: create table #EmployeeSystemsMaster(EmployeeSystemID int, EmployeeSystemName nvarchar(150)) insert into #EmployeeSystemsMaster...
SQL Server data masking
Can you able to mask data in sql server 2012? If yes, would it...
Ask SSC