SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


interview questions


interview questions

Author
Message
Nicholas Cain
Nicholas Cain
SSChampion
SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)

Group: General Forum Members
Points: 13090 Visits: 6200
This could be an indispensable guide for interviews :-D
http://www.howtonailaninterview.com/



Shamless self promotion - read my blog http://sirsql.net
kollasanjeevarao
kollasanjeevarao
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 3
Hi,

you can find a good set of sql server interview questions
at the following link.

http://www.wiziq.com/online-class/292863-sql-server-interview-questions

Thanks
Regards
Kolla Sanjeeva Rao
manolomalaga
manolomalaga
SSC Eights!
SSC Eights! (805 reputation)SSC Eights! (805 reputation)SSC Eights! (805 reputation)SSC Eights! (805 reputation)SSC Eights! (805 reputation)SSC Eights! (805 reputation)SSC Eights! (805 reputation)SSC Eights! (805 reputation)

Group: General Forum Members
Points: 805 Visits: 172
Great place, thank you
humanier
humanier
Valued Member
Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)

Group: General Forum Members
Points: 60 Visits: 2
paul.starr (4/17/2009)
any info on really good interview questions for a sql server dba?


Check here - MS SQL Interview Q&A

==================
Visit my blog!
deepaksharma21
deepaksharma21
SSC-Enthusiastic
SSC-Enthusiastic (111 reputation)SSC-Enthusiastic (111 reputation)SSC-Enthusiastic (111 reputation)SSC-Enthusiastic (111 reputation)SSC-Enthusiastic (111 reputation)SSC-Enthusiastic (111 reputation)SSC-Enthusiastic (111 reputation)SSC-Enthusiastic (111 reputation)

Group: General Forum Members
Points: 111 Visits: 117
First of All,

I should be aware of the problem before the business looking for the answer. If not I will confirm that I am wokring on the issue and will update you in 10-15 min.

10-15 min is always enough for you to understand the Problem. I will take the following steps.
1. Check the database server error log for any obvious failure for the last 30 min.
2. Check if the network connectivity is fine. Telnet the SQL on the configured port fro the application server
3. Check the server if there is disk space issue.

Now I have an more information to handle the problem and probably understood what fixes need to apply.

Update myLead/Manager that abou the issue and suggest the next steps. Once he approved the changes then go ahead and apply the changes to resolve the issue.

I and my manager shoould have an idea of how much time it takes fix these klind of problem. So he can communicate to relevent people.

I willl crack on appying the fixes.

.....
Gail Wanabee
Gail Wanabee
Hall of Fame
Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)

Group: General Forum Members
Points: 3578 Visits: 1575
paul.starr (4/17/2009)
any info on really good interview questions for a sql server dba?


In addition to everything else that has been mentioned in this thread, I would recommend that you study and be prepared to answer questions about best practices. There are best practices for virtually every aspect of DBA work so there is a lot to study.

In addition to being prepared to answer questions about/discuss best practices, I would also recommend that you interview your prospective employer. Unless you have no other options, you probably will not want to work for a prospective employer who has no interest in, no knowledge of, nor any commmitment to the implementation of best practices. To work in a "non-best practices" environment means constant firefighting, bandaiding, and generally reacting to problems rather than being a proactive DBA.

It's not much fun.

LC
best_yunus
best_yunus
Valued Member
Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)

Group: General Forum Members
Points: 63 Visits: 122
What is called Object in SQL Server? Tell me some objects name?
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (382K reputation)SSC Guru (382K reputation)SSC Guru (382K reputation)SSC Guru (382K reputation)SSC Guru (382K reputation)SSC Guru (382K reputation)SSC Guru (382K reputation)SSC Guru (382K reputation)

Group: General Forum Members
Points: 382034 Visits: 43008
best_yunus (5/5/2012)
What is called Object in SQL Server? Tell me some objects name?


Google. ;-) Seriously... Google for "sql server objects" and you'll find out. To summarize, just about anything you can name in SQL Server is an "object".

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
best_yunus
best_yunus
Valued Member
Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)

Group: General Forum Members
Points: 63 Visits: 122
thanks
tom.lemmer
tom.lemmer
SSC Rookie
SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)

Group: General Forum Members
Points: 25 Visits: 39
Applying for a DBA position can involve a lot of different knowledge areas. You need to understand what the job is that you are applying for and determine if your skills match the position. There are jobs that are more involved in the database administration portion of the work and there are other jobs that need more database developer, SSIS, or SSRS background. While these could all be advertised under the label of Database Administrator you would need to look at the details of the position being posted to better understand what the company is looking for. There are different sites for different points about certain topics. You can start by looking up best practices for setting up databases, indexing, and so forth. As you find articles that peak your interest in certain area's you can branch off into those areas and learn more. One of the things a good DBA has is the ability to observe events to capture what is going on, that helps them solve the issue or to research the issue to find the solution. The one thing about technology is that if you want to keep your job and be an asset to your company you never stop learning so forget about just looking up the data just for the interview, it will be a continual process if you want to be successful. I have attached a document that pretty much sums up characteristics any good employee should have but is written for DBAs. I do not endorse the products listed, I just think it's a good summary.
Attachments
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search