Home Forums SQL Server 2005 T-SQL (SS2K5) CASE in WHERE clause RE: CASE in WHERE clause

  • March 13, 2013 at 9:07 pm

    #1596789

    Forgot to include cache

    Also checking statistics (SET STATISTICS IO ON) and clearing cache [/b]before executing each stored proc.

    --Do not run in PROD!!!

    DBCC FREEPROCCACHE

    DBBC DROPCLEANBUFFERS