Some Intreview questions

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Career » Employers and Employees » Some Intreview questions

Some Intreview questions

Rate Topic

Display Mode

Topic Options

Author

Message

SKYBVI

Posted Saturday, July 21, 2012 6:17 AM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, April 30, 2013 2:38 AM
Points: 1,197, Visits: 3,225

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

GilaMonster

Posted Saturday, July 21, 2012 6:37 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 8:44 AM
Points: 37,645, Visits: 29,898

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

Dev

Posted Saturday, July 21, 2012 8:39 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 2:05 PM
Points: 2,013, Visits: 1,566

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~

Post #1333355

« Prev Topic | Next Topic »

Permissions