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.

How do you delete a data source?

1011

---

How to delete an existing row with delete statements in ms sql server?

1093

---

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

1916

---

How many full-text indexes can a table have?

974

---

Explain intellisense for query editing

1029

---

What is difference between index and primary key?

1100

---

Can we write trigger for view?

1013

---

What is a ddl statement?

914

---

How do I get to sql server configuration manager?

1010

---

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

1048

---

Explain different types of index?

1064

---

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

1059

---

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

2077

---

What is in place upgrade in sql server?

1045

---

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

933

---