2023-12-27
481 reads
Foreign Keys (FK)
2023-10-27
431 reads
2023-10-20
450 reads
2018-08-27
849 reads
2018-06-05
864 reads
2016-08-16
1,331 reads
2016-08-02
1,358 reads
2016-07-05 (first published: 2016-05-26)
4,577 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,776 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)
6,099 reads
Blogs
Speaking at the NYC Lunch and Learn DevOps Devour Hour
By Steve Jones
This Friday is the NYC DevOps Devour hour, which is actually 3 hours. Plus...
What’s new in SQL Server 2025 CTP 2.0
Three years ago, when the first public preview of SQL Server 2022 (CTP 2.0)...
Monday Monitor Tips: Beyond SQL Server
By Steve Jones
Redgate Monitor works with more than SQL Server. Some big changes were announced recently,...
Forums
Remove ISNULL FROM left join to make SARGAble
Hi, I'm trying to make the below query SARGable by removing the ISNULL function...
SQL 2022 upgrade issues
We're about to upgrade our SQL 2017 Standard to 2022 standard. We have 1...
Script-Drop Orphan users from SQL Server Database
Comments posted to this topic are about the item Script-Drop Orphan users from SQL...
Question of the Day
The Minimal Linked Server
What is the minimal number of parameters to add a linked server with sp_addlinkedserver?
See possible answers