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.
SQL SERVER – Change Collation of Database Column – T-SQL Script
Just a day before I wrote about SQL SERVER – Find Collation of Database and Table Column Using T-SQL and I have received some good comments and one particular question was about how to change collation of database. It is quite simple do so. Let us see following example. USE…
Read MoreSQLAuthority News – Download Microsoft SQL Server Management Pack for Operations Manager 2007
Note: Download Microsoft SQL Server Management Pack for Operations Manager 2007 by Microsoft The SQL Server Management Pack provides the capabilities for Operations Manager 2007 to discover SQL Server 2000, 2005 and 2008 installations and components and to monitor them, primarily from the perspective of availability and performance. The…
Read MoreSQL SERVER – Roadmap of Microsoft Certifications – SQL Server Certifications
In these times of economical slowdown, more and more IT professionals are concerned about their jobs and their qualifications. It is a common trend for developers to start looking for ways to update their skills when jobs are not secure. Pure knowledge and real world work experience are always a…
Read MoreSQL SERVER – Interesting Observation – Use of Index and Execution Plan
Previously I wrote article about SQL SERVER – Interesting Observation about Order of Resultset without ORDER BY and I have received tremendous response from my readers by emails and comments. Readers demanded that I should have written little more for the same subject. As I really liked the subject myself…
Read MoreSQL SERVER – Interesting Observation about Order of Resultset without ORDER BY
Today I observed very interesting little thing about SQL Server and I felt that I should share this with my readers. I ran following two queries and found that I am getting different result-set. When I carefully observed I found that actually the result was same but order of the…
Read MoreSQLAuthority News – RML Utilities – Usage and Additional Help
Yesterday I wrote about SQLAuthority News – Download RML Utilities for SQL Server. I received many emails where different developers requested how to find additional help regarding RML Utilities. Few users reported that they are not able to install RML Utilities because of some reporting service pre-requisite. If RML Utilities…
Read More