When you’re performance tuning T-SQL one thing you want to make sure is that you are have a consistent environment to test your changes/modifications. Two commands that will help ensure that your environment stays close to the same for each iteration of your script are DBCC DROPCLEANBUFFERS and DBCC FREEPROCCACHE. Now for all those people testing [...]
My Thoughts on SQL Server and anything else I can think of…
