UPDATE : Updated this query with bug fixed with one more enhancement SERVER – 2008 – 2005 – Find Longest Running Query – TSQL – Part 2.
Recently my company owner asked me to find which query is running longest. It was very interesting that I was not able to find any T-SQL script online which can give me this data directly. Finally, I wrote down very quick script which gives me T-SQL which has ran on server along with average time and maximum time of that T-SQL execution. As I keep on writing I needed to know when exactly logging was started for the same T-SQL so I had added Logging start time in the query as well.
SQLAuthority News – Happy New Year – 5 SQL New Year Resolutions
Happy New Year to All of YOU! Let us start year 2009 with word of wisdom from Albert Einstein. I feel that you are justified in looking into the future with true assurance, because you have a mode of living in which we find the joy of life and the…
Read MoreSQLAuthority News – Recap Year 2008 – Two Most Important Event of My Life
Year 2008 is about to complete in next few hours. It was one of the most interesting year for me in my life. There were so many things happened and fortunately all of them are good. If I have to list events special to me in year 2008 there can…
Read More
SQLAuthority Author Visit Report – Tech Meetings – Recession – Job Market – Consolidation of Servers
In this blog post, I will discuss various topics which are related to various DBAs and Developers discussed in the recent market.
SQL SERVER – 2008 – Certification Path Complete Download PDF
Microsoft Certification are very important for any developer’s career. I personally have acquired MS certification before and while practicing for MS Certification I learned a lot personally. Developers who are interesting in upgrading themselves with Microsoft Certification must download certification path PDF.
SQL SERVER – Fix : Msg 15151, Level 16, State 1, Line 3 Cannot drop the login ‘test’, because it does not exist or you do not have permission
I got following error when I was trying to delete user ‘test’ with ‘SA’ login. I was little surprised but then I tried to delete with the windows authenticated systemadmin account. Once again I got the same error. Msg 15151, Level 16, State 1, Line 3 Cannot drop the login…
Read More
SQL SERVER – Add Any User to SysAdmin Role – Add Users to System Roles
The reason I like blogging is follow up questions. I have wrote following two articles earlier this week. I just received question based on both of them. Before I go on questions, I recommend to read both of the article first. Both of them are very small article so they are quick to read.