July 21, 2012 at 6:17 am
Hi,
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 ?
Regards,
Skybvi
Regards
Sushant Kumar
MCTS,MCP
July 21, 2012 at 6:37 am
SKYBVI (7/21/2012)
1.What precautions will you take before updating a million rows in a table in a production database.?
That's asking for what you do. So, what precautions do *you* take before updating a million rows in a production database? Think about what can go wrong.
2.what differences are in the results if we do sp_who2/who or run a DMV?
That you can test
3. How to know who inserted/deleted/modified any things in a table OTHER than by using trigger?
Google: SQL Auditing
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?
Google: SQL performance monitoring
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 ?
That you can test. Start management studio, write such a query, look at the exec plan.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 21, 2012 at 8:39 am
In continuation to what Gail said...
1.What precautions will you take before updating a million rows in a table in a production database.?
Google: Backup, Locking / Blocking & Commit / Rollback.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy