SQL Server Performance Forum – Threads Archive
Que and Ans
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.
2. what will happen when only .ldf file of any database is deleted ?
quote:
3. how I can see the contain of any log file?
By using a third party log exploring software.
3. how I can see the contain of any log file?
quote:
4. what are the daily task of any SQL server DBA?
This will help.4. what are the daily task of any SQL server DBA?
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
5. I have two database one at offshore and 2nd is at onsite.
How I can synch these two database using internet?
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
6. what is replication ? purpose of replication?
how you will synch the replic database with the original database?
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
7. what is the o/p of following queries
select * from table where 1=2
select * from table where 1=1
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
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
quote:
9. max size of pages in SQL server.
In SQL Server 2000, the page size is 8 KB
Roji. P. Thomas9. max size of pages in SQL server.
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.
]]>