Hi for few days i am going to work at client side which has sql server 2000. I am knew to it show just want to know where to look for helps .
I mean suppose i want to know which query are executing at present then where to look . dbbc inputbuffer does not shows complete query then where to look.
I want to know how much time it would require to complete a database backup/restore then which queries to use.
some faster way to know fragmenatation in table
Thanks and regards
Anoop