Conor vs. more SARGable predicates

I got another question in the mail this week from another reader:   Hi Conor Thanks for an interesting blog. Maybe you have the answer to this question: Why I SQL Server having performance problems with these types of expressions: —————————————————————————————— DECLARE TABLE dbo.Archive( LastName varchar(50), Reference INT, SocialSecurityNumer VARCHAR(10) ) —————– DECLARE dbo.MySearch @Reference…


Conor vs. Join Search Space

I received a question this week from a reader about how SQL Server determines the join order if there are more than 6 joins in a query. There are a lot of details about how SQL Server’s optimizer works here, and some of them are beyond the level of detail that I can/will share publicly….