How many .ndf files can we create in Sql server 2005?

2 Answers   Wipro,

---

What about UPDATESTATISTICS ?

2 Answers   HCL, Intelligroup,

---

Can a function call a stored procedure in sql server?

0 Answers  

---

what is Constraint? How many types of constraints in SQL ?

38 Answers   HCL, IBM, NIIT, Wipro,

---

What are the differences between local and global temporary tables?

0 Answers  

---

---

Can a table have 2 foreign keys?

0 Answers  

---

What is replication with database mirroring? : sql server database administration

0 Answers  

---

if a parameter is not send to a stored procedure what type of identifier is to be used in Stp and if that parameter is not feed to the a query inside the Stp how to validate with out useing IF condition

1 Answers   Aviva,

---

What are the steps to process a single select statement?

0 Answers  

---

Find top Nth employee from each department in terms of salary?

13 Answers   RealPage,

---

Do you know the isolation level that sql server support?

0 Answers  

---

If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?

2 Answers  

---