Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Some Intreview questions Expand / Collapse
Author
Message
Posted Saturday, July 21, 2012 6:17 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, June 10, 2014 6:14 AM
Points: 1,200, Visits: 3,237
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
Post #1333342
Posted Saturday, July 21, 2012 6:37 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:18 PM
Points: 40,658, Visits: 37,117
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 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1333344
Posted Saturday, July 21, 2012 8:39 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 6:53 PM
Points: 1,932, Visits: 1,589
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.


Dev

Devendra Shirbad | BIG Data Architect / DBA | Ex-Microsoft CSS (SQL 3T)
*** Open Network for Database Professionals ***

LinkedIn: http://www.linkedin.com/in/devendrashirbad
Post #1333355
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse