Answer Posted / naren

clustered index is created on actual data.

Non clustered index ix created on pointer of data.

If there is primary key by default clustered index is
created.
else non clustered index created.

only one clustered index is possible to create.


249 non clustered indexex can be created.

How can you find out which stored procedures are recompiling?

737

---

How to use column default values in insert statements in ms sql server?

768

---

How to get a list of all tables with "sys.tables" view in ms sql server?

819

---

when would you go for denormalization? : Sql server database administration

675

---

Mention the differences between substr and charindex in sql server.

753

---

How to access the deleted record of an event?

787

---

What do you understand by intent locks?

795

---

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

787

---

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

1996

---

Explain transaction server implicit?

739

---

What is logon trigger?

774

---

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

841

---

How to handle error or exception in sql?

738

---

What is dbcc? Give few examples.

785

---

Explain few of the new features of sql server 2008 management studio

724

---