I am a newbie in SQL Server. Today i came across the PerformanceStatisticsScript. I found it in SQLNexus.codeplex.com and i am sure many on this forum would be using this script. In this script the author uses the condition as
IF '%runmode%' = 'REALTIME'
I am not able to relate this condition with the stuff i know about SQL Server.
Morever the author is using many tables like tbl_BLOCKING_CHAINS,tbl_HEADBLOCKERSUMMARY etc.
Create table scripts is present but it is present in a If condition , which according to me would never execute. Hence .....hhhmmmm....should this table be present prior running this scripts or what is the concept