Answer Posted / 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.

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

899

---

Why we should not use triggers?

919

---

Is oracle faster than sql server?

888

---

How is SQL Azure different than SQL server?

223

---

Explain the properties of a relational table?

976

---

How to delete duplicate records based on single column from a table?

995

---

Can you explain about buffer cash and log cache in sql server?

904

---

Do you know what are the reporting services components?

917

---

How to insert stored procedure result into temporary table?

978

---

What are window functions in sql server?

936

---

How to remove duplicate rows from table?

1162

---

Tell about MOM Tool(Microsoft Operator Manager)?

1854

---

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

960

---

How you can change a cross join into an inner join?

908

---

What is difference between sql and sql server?

937

---