Answer / dilipkumar

there are 1 clustered index and...
in 2008 sql server total 249 non clustered index
in 2010 sql server total 999 non clustered index
in 2012 sql server total 999 non clustered index.

Answer / vikram

there are 1 clustered index and...
in 2005 sql server total 249 non clustered index
in 2008 sql server total 999 non clustered index
in 2010 sql server total 999 non clustered index
in 2012 sql server total 999 non clustered index.

What area unit the various kinds of info compression introduced in sql server 2008?

0 Answers  

---

IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

0 Answers  

---

What is difference between index and primary key?

0 Answers  

---

Explain alternate key, candidate key and composite key in sql server?

0 Answers  

---

can i write function in stored procedure and stored procedure in function and nested procedure.Give one example for each question?

1 Answers   Cap Gemini, TCS,

---

---

What the different components in replication and what is their use?

0 Answers  

---

What is a view?

6 Answers  

---

How to change server name in sql server?

0 Answers  

---

How can u convert the Date to String?

6 Answers   Microsoft, TCS,

---

What is wide table?

0 Answers  

---

what is difference between view and Dip.

0 Answers   IBM, L&T,

---

Can we call stored procedure in view in sql server?

0 Answers  

---