You have chosen a strange title for the article. It`s starts with "High-Performance..." but there is no performance comparison between Windowed Functions and other approaches. The article itself is interesting...

Nice article. But I can see 1 significant problem. To perform ErrorLog scan the SQL Server must be running and healthy on target host. But usually most interesting things appears...

Let me reduce original article to this: http://msdn.microsoft.com/en-us/library/ms143799(v=sql.110).aspx

+5 cent's of mine

select top 100

name

,

convert(datetime,(convert(varchar(8),h.run_date)))

+(

+substring (right( '000000'+(convert (varchar (6), h.run_time) ),6),1,2)

+':'+substring (right( '000000'+(convert (varchar (6), h.run_time) ),6),3,2)

+':'+substring (right( '000000'+(convert (varchar (6), h.run_time) ),6),5,2)

)

begining

,

convert (varchar ,convert(int,reverse (substring...

Hi, Kimberly. I believe your decision is not to exact. The idea to have a servers list for centralized monitoring is pretty reasonable. But tracking DB-settings changes by results of...