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.

Explain indexes disadvantages?

752

---

How to list all columns in a table using odbc_columns()?

727

---

What does REVERT do in SQL Server 2005?

711

---

What is self join in sql server joins?

737

---

What are diverse clauses that form a part of sql?

796

---

---

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

706

---

What is difference between inner join and join?

735

---

what is checksum in sql server.........???

1376

---

How do I start sql server 2017?

703

---

What is function of CUBE ?

760

---

What is primary key index?

706

---

What is schemabinding a view?

696

---

How to execute stored procedure in select statement sql server?

714

---

Explain atomicity?

730

---

Mention the differences between local and global temporary tables.

747

---