How Check Constraints MIGHT Improve Your Queries and Missing Index Requests
14 Comments
The more SQL Server knows about your data, the better your query plans can get. Say you’ve got an app that’s designed to store multiple companies in a single database – but you don’t actually use it that way. All of the data in a given database is actually for the same company. We’ll use…
Read More