Answer / rajendra

Cold Backup and Hot Backup terms are used by Oracle. These
terms are not available In MS SQL Server.

Cold Backup: - Takes the Database offline and copy database
files to different loction is called cold backup in Oracle.

Hot Backup:- Taking the Database backup when the Database
is online.

Answer / guenter

i think both of the above answers are right:
Cold Server backups:
http://www.microsoft.com/licensing/software-assurance/cold-
backup.aspx
Oracle Database Cold Backup:
http://www.oracle.com/technology/pub/articles/havewala-rman-
grid.html

Answer / samriti

Cold Server backups goes for those machine which have
software installed and configured and then turned off.

Hot Server backups are those which frequently are turned
on and ready to move into production mode immediately.

Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?

0 Answers  

---

How will you fine tune a stored procedure or what are the steps that should be taken to fine tune or optimize a stored procedure?

1 Answers   Logitech, Mphasis,

---

Can primary key be a foreign key?

0 Answers  

---

When you first load SQL SERVER you will startup with what all databases?

3 Answers   CompuSol,

---

Explain what is cte (common table expression)?

0 Answers  

---

---

What is change data capture (cdc) feature?

0 Answers  

---

What do you mean by an execution plan? Why is it used? How would you view it?

0 Answers  

---

Is there any difference between primary key and unique with the not null condition?

0 Answers  

---

What is the difference between cross join and Full outer join?

1 Answers   HP, Standard Bank,

---

What is raid, and how it can influence database performance?

0 Answers  

---

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

0 Answers  

---

explain different types of jions with examples briefly?

1 Answers   Zensar,

---