Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Intentional Normalization Violation RE: Intentional Normalization Violation
Koen Verbeeck
SSC Guru
Points: 259085
More actions
September 30, 2016 at 5:55 am
#1904124
Maybe a filtered index on the order status table that only keeps the current statuses?
Need an answer? No, you need a questionMy blog at https://sqlkover.com.MCSE Business Intelligence - Microsoft Data Platform MVP