1. what will happen when .mdf and .ldf file of any database is deleted ? 2. what will happen when only .ldf file of any database is deleted ? 3. how I can see the contain of any log file? 4. what are the daily task of any SQL server DBA? 5. I have two database one at offshore and 2nd is at onsite. How I can synch these two database using internet? 6. what is replication ? purpose of replication? how you will synch the replic database with the original database? 7. what is the o/p of following queries select * from table where 1=2 select * from table where 1=1 8. I have one table as follow col1 col2 ----- ----------- A 10 A 15 B 15 B 5 C 25 D 2 I want a query for the record those have the aggregates greater than 20 9. max size of pages in SQL server.
quote:Originally posted by shubhada99 1. what will happen when .mdf and .ldf file of any database is deleted ? The database will go to suspect mode. quote: 2. what will happen when only .ldf file of any database is deleted ? The database will go to suspect mode. quote: 3. how I can see the contain of any log file? By using a third party log exploring software. quote: 4. what are the daily task of any SQL server DBA? This will help. http://www.dbazine.com/ofinterest/oi-articles/dba-1 quote: 5. I have two database one at offshore and 2nd is at onsite. How I can synch these two database using internet? You can set up a linked server quote: 6. what is replication ? purpose of replication? how you will synch the replic database with the original database? Seehttp://databases.about.com/cs/sqlserver/a/aa041303a.htm quote: 7. what is the o/p of following queries select * from table where 1=2 select * from table where 1=1 A blank result set quote: 8. I have one table as follow col1 col2 ----- ----------- A 10 A 15 B 15 B 5 C 25 D 2 I want a query for the record those have the aggregates greater than 20 Refer to the HAVING clause quote: 9. max size of pages in SQL server. In SQL Server 2000, the page size is 8 KB Roji. P. Thomas SQL Server MVP http://toponewithties.blogspot.com
Did the interview go well? [<img src='/community/emoticons/emotion-5.gif' alt='' />]<br /><br />--<br />Frank Kalis<br />Moderator<br />Microsoft SQL Server MVP<br />Webmaster:<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a>
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by FrankKalis</i><br /><br />Did the interview go well? [<img src='/community/emoticons/emotion-5.gif' alt='' />]<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />Not very well,I guess<br /><br />Roji. P. Thomas<br />SQL Server MVP<br /<a target="_blank" href=http://toponewithties.blogspot.com>http://toponewithties.blogspot.com</a><br />
What about Question No 10? [<img src='/community/emoticons/emotion-5.gif' alt='' />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
Question No 10: Job offer [<img src='/community/emoticons/emotion-1.gif' alt='' />] ... Would you like job our Super DBA team ?<br /><br /><br />MohammedU.<br />Moderator<br />SQL-Server-Performance.com<br /><br />All postings are provided “AS IS†with no warranties for accuracy.<br />
Question number 10 was actually a statement, not a question! Roji. P. Thomas SQL Server MVP http://toponewithties.blogspot.com
Q 10 will be, after answering all above how much salary I can expect or demand [<img src='/community/emoticons/emotion-1.gif' alt='' />].<br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing. <hr noshade size="1">The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.</i></font id="size1"></font id="teal"></center>
Where's Q 10? The post was edited by Satya.. Did you knock it off the list? *********************** Dinakar Nethi SQL Server MVP *********************** http://weblogs.sqlteam.com/dinakar/
Nope, just adding up the fun bit. I have edited it to fit the topic in this forum until we get a seperate section for beginners type of questions. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
