i had been asked some questions by interviewer, which i wanted to know the answers.
I already googled up the answers and couldnt find some.
1.What precautions will you take before updating a million rows in a table in a production database.?
2.what differences are in the results if we do sp_who2/who or run a DMV?
3. How to know who inserted/deleted/modified any things in a table OTHER than by using trigger?
4. If our users are running sprocs daily through any applicaton; what will you create to see the performances of those sprocs
on a daily basis?
5. If we run a query select * from where order by...example of a query.
What is the order of execution we will see in a Query execution plan ?