Important Note: These are yesterday’s links. Not today’s. That’s why the date is wrong.
SQL Server
Really Search Cache for Execution Plans Jason Strate revists his code that finds the last plan that was used for a procedure.
Reasons for NOT using Varchar(MAX) Pat Wright brings back the argument of why you should or shouldn’t use varchar(max). You [...]
Just a quick reminder that I will be presenting on Dynamic SQL tomorrow at 1pm EST for the PASS AppDev SIG. Details are available in my previous post. Hope to see you all there.
SQL Server
SQL Server and NULL Values, Revisited Aaron Alton takes a good look at NULL values and makes reference to post on the same topic. They both provide good information and well-founded opinions on NULLs and their place in the database.
Does a GUID make a good clustered key? This is a subject that is [...]