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

How to download microsoft sql server 2005 express edition?

978

---

can you instantiate a com object by using t-sql? : Sql server database administration

963

---

A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

905

---

How to convert a table data in XML format in sql server?

2495

---

How to recover from sql injection? : sql server security

958

---

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

991

---

What is Federation and Federation Member?

92

---

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

938

---

Write a sql query to sort on different column name according to the parameters passed in the function?

855

---

Can we join two tables without primary key?

982

---

What is the difference between writing data to mirrored drives versus raid5 drives

873

---

How to select some specific columns from a table in a query in ms sql server?

946

---

What is difference between commit and rollback when used in transactions?

909

---

How to receive returning result from a query?

1039

---

What are the difference between primary keys and foreign keys?

915

---