June 23, 2010 at 5:28 am
1) Can we generate Trigger for two table and give a example ?
2) Describe performance tuning steps for ( table , Stored procedure, Query ) for microsoft sql server. ?
June 23, 2010 at 5:35 am
boy these read just like homework questions.
what do you think the answers are?
troy2.net (6/23/2010)
1) Can we generate Trigger for two table and give a example ?
you can create a trigger on one table that affects multiple tables. a classic example would be sending update and delete rows that changed into an audit table.
2) Describe performance tuning steps for ( table , Stored procedure, Query ) for microsoft sql server. ?
tuning is a broad subject. you'd really need to define the question better. you can't tune a table, only queries, whether ad hoc or as part of a stored procedure. Have you studied how to read an execution plan in your class yet?
Lowell
June 23, 2010 at 5:35 am
Homework? Interview questions?
The first I'm not sure what you're asking, the second is rather vague.
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
June 23, 2010 at 5:49 am
I know only basic in Sql server
Yes these are interview question.
I would like to learn Sql Server more so i want the answer.
please be patience to answer the question.
June 23, 2010 at 5:50 am
Yes its , Interview Question..
Actually they asked the same for me to....
June 23, 2010 at 5:52 am
We're not going to give you the answer to interview questions. The point of an interview is to see what you know, not what other people know.
For triggers, start with Books Online and read up on them. For performance tuning, i suggest a google search, it's a huge topic.
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
June 23, 2010 at 5:54 am
Well gud answer
It has been asked for , i do no , i would like to know the answer so through this i will learn those things to do welll on further..
June 23, 2010 at 6:25 am
troy2.net (6/23/2010)
Well gud answerIt has been asked for , i do no , i would like to know the answer so through this i will learn those things to do welll on further..
If you REALLY wont the job , dont answer that you know how to tune for performance.
You will be caught out very quickly , fired and be unemployable.
The correct answer is (IMO)
"I dont know. Its a massive topic, im reading up right now. Ive have some really good resources from ... and look forward to implementing in a live environment what ive been practising."
June 23, 2010 at 11:05 pm
am afraid with the subject tag "SQL Doubt -1". OP may have series of interview questions..." SQL doubt -2" etc...;-)
June 27, 2010 at 9:52 pm
OffCourse
but now i have changed my mind not posting those question here..
June 29, 2010 at 3:56 am
START PROGRAMMING.....
Prashant Bhatt
Sr Engineer - Application Programming
June 29, 2010 at 6:47 am
Datatypes , Joins , Trigger , View , and also they ask scenarios to write a query, Index and types , etc..
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply