What are the types of database recovery models?

0 Answers   HCL,

---

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

0 Answers  

---

Write down the syntax and an example for create, rename and delete index?

0 Answers  

---

What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

0 Answers  

---

How to find out what is the default collation in a database?

0 Answers  

---

what is a traditional network library for sql servers? : Sql server database administration

0 Answers  

---

Explain few examples of stored procedure over triggers?

0 Answers   ADITI,

---

How to write a query with a full outer join in ms sql server?

0 Answers  

---

one of my database size is 2gb and Unrestricted Growth for Data file up to 10%.But every day after day I am getting Primary Data file is full 99.999 please take appropriate actions.Why it is? Even disk space is also not full,but still I am getting the alerts.

1 Answers   Cognizant,

---

How to concatenate two binary strings together?

0 Answers  

---

What will be the maximum number of index per table?

0 Answers  

---

What is Peer to peer Replication?

1 Answers   CarrizalSoft Technologies, HCL,

---