Answer Posted / sanjay kumar dinda

Two types of indexes are there in SQL Server
1. Clustered Index
2. Non-Clustered Index

We can create only 1 Clustered index in a table as it re-
orders the data of the table
We can create upto 249 Non-Clustered index in a table...

How can change procedure in sql server?

1050

---

What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

1014

---

whats new about truncate in sql server 2008?

2492

---

Difference between report and query parameter. Why do we need different type of parameter?

941

---

What is user defined stored procedures?

924

---

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

902

---

Can sub report data source be different from that of the parent report?

141

---

New concepts of sql server 2005 use in your project.

2354

---

what is a mixed extent? : Sql server administration

1091

---

In which files does sql server actually store data?

894

---

Distinguish between commit and rollback?

947

---

Why we need to use secondry database file? though, we can do same work using primary database file also.

6864

---

Explain the commands in sql server?

1029

---

How retrieve field names from the table in SQL through JAVA code?

1895

---

How to skip remaining statements in a loop block using continue statements?

988

---