Ars Technica

TSQL theory: Is NOT IN LIST "faster" than LEFT JOIN and WHERE field NULL?

SELECT * FROM Students AS Std INNER JOIN StudentSuspensions AS Sus ON Std.StudentID = Sus.StudentID WHERE Sus.EndDt IS NOT NULL That would not work because not ALL students have had suspensions. So ...
Ars Technica

TSQL: Dealing with NULL parameter passing for WHERE statement

SELECT * FROM tbl_Students WHERE FirstName LIKE '%' + @FirstNameString + '% AND LastName LIKE '%' + @LastNameString + '% Anyway, I want the option for the user to specify one or both. So they can ...