Actually i found a pretty good refference

http://www.sql-server-pro.com/sql-where-clause-optimization.html

Thats actually what i was looking for. So is it just udfs?

you could run the follwoing select on each sql instance or u could create 1 central box who has a linked server connection to each instance and run the below...

very cool Sachin Nandanwar. For some reason i always had issue understanding the pivot. seems really simple right there. thx

i believe there is tsql way to perform what this proc does. Does anyone have any insight to how you could rewrite the md5 to perhaps a sql function? Can...

here is an article similar to ur issue.

http://blogs.msdn.com/b/sqlserverfaq/archive/2010/03/31/unable-to-connect-to-sql-server-2008-instance-after-applying-sp1.aspx

easy now. Not everyone at once