SQL Server Performance

Que and Ans

Discussion in 'Getting Started' started by shubhada99, Apr 16, 2007.

  1. shubhada99 New Member

    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.
  2. Roji. P. Thomas New Member

    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
  3. FrankKalis Moderator

    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>
  4. Roji. P. Thomas New Member

    <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 />
  5. Madhivanan Moderator

    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
  6. MohammedU New Member

    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 />
  7. Roji. P. Thomas New Member

  8. satya Moderator

    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>
  9. ndinakar Member

    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/
  10. satya Moderator

    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.

Share This Page