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