Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

0 Answers  

---

Do you know what is lock escalation?

0 Answers  

---

What are sub-queries? Give example? In which case sub-queries are not feasible?

4 Answers   Infosys,

---

What is log shipping?

0 Answers  

---

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

0 Answers  

---

What is inline table-value user-defined function?

0 Answers  

---

hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting

2 Answers  

---

What all db objects can be found in MSDB database of a SQL Server instance?

2 Answers   Accenture,

---

what is difference between primary key and Unique

8 Answers  

---

Is port 1433 secure?

0 Answers  

---

what is the importence of the trigger in sqlserver2000?

1 Answers   ATI,

---

What is the difference Between Sql-server 2000 & 2005

3 Answers   Value Labs, Wipro,

---