Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kirandba2k5
Starting Member
1 Post |
 Posted - 2011-12-15 : 00:47:43
|
| Yesterday i attended the interview on sqldba position.they are asking these questions.please answer to these questions.1)what is your Daily work after entering into the office as a sql dba?2)major issues you solved in your total experience: give me some examples with explanation? 3)).how can we add new articles to publication in replication, how those will be updated at subscription? 4)Can we apply isolation levels manually to sql server queries? 5)How frequent can u check fragmentation? 6)scenarios:1).my database is online with the application since 1 year, my query is executed properly up to yesterday, today when I executed the same query ,it is executed but took long time, what are the reasons, how can u resolve the issue? 7)How can u solve the application time out issue? 8)if u got an issue like, hello dba I am unable to connect to database, how can we resolve? 9)My principal server is in one city, for disaster recovery, which method will u suggest, if want to keep my stand by server in other city and I have no backups? thank you:) |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-15 : 03:02:37
|
| Did you serach for these in google? there are lots of sites avaiable providing info on these------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2011-12-15 : 11:49:29
|
| In Re: "and I have no backups"We have an automated resume updater which we use to cover this situation. It searches job boards and such looking for the key words "No experience necessary". <Wink, wink>=======================================Faced with the choice between changing one's mind and proving that there is no need to do so, almost everyone gets busy on the proof. -John Kenneth Galbraith |
|
|
|
|
|
|
|
|
Please answer to these questions