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 is the difference between Delete and Truncate

4 Answers   CarrizalSoft Technologies, Geo Research Centre,

---

What are the source of constraints?

0 Answers  

---

How do I edit a stored procedure in sql server?

0 Answers  

---

What is the language structure to add a record to a table?

0 Answers  

---

what is replication? where do u use Go Keyword?

1 Answers   Satyam,

---

create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?

8 Answers   IBM,

---

Selet all the data from table where last name is n of employee

2 Answers  

---

What are the approximate numeric data types?

0 Answers  

---

what is bit data type? and what are the information that can be stored inside a bit column?

2 Answers  

---

What is sparse columns of sql server 2008?

0 Answers  

---

what is diffence between replicaion and logshipping?

1 Answers  

---

What is blocking in SQL Server? If this situation occurs how to troubleshoot this issue

2 Answers   IBM,

---