Viewing 4 posts - 1 through 4 (of 4 total)
But when I am trying to execute the script on SQL Server 2005 with sysadmin rights, it's giving me below error on "CROSS APPLY sys.dm_exec_sql_text(Blocking.most_recent_sql_handle) AS BlockingSQL" line.
Error : Incorrect...
December 16, 2013 at 8:13 am
hi Rajib, Thanks for sharing a useful script.. Is this applicable for SQL Server 2008 and above?/
December 16, 2013 at 7:33 am
Thanks Dave...
One more question:
Will this query (Finding queries to tune) be executed in Master DB only???
June 11, 2013 at 8:54 am
Thanks for useful queries and suggestions.. I am writing for the first time on SQL Server Central.
I am trying to execute the query on Microsoft SQL Server 2008 R2...
June 11, 2013 at 8:29 am
Viewing 4 posts - 1 through 4 (of 4 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy