What are different types of database indexes?

0 Answers  

---

what is the use of database index(apart from the last searching of records) and what is the use of composite key?

1 Answers  

---

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  

---

How you can find out if an index is useful to the optimizer?

0 Answers  

---

Does partitioning help performance?

0 Answers  

---

Define union, union all, minus, intersect?

0 Answers  

---

What is partition in sql server?

0 Answers  

---

What are different backups available in sql server?

0 Answers  

---

Explain “@@rowcount” and “@@error” in sql server?

0 Answers  

---

code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

0 Answers   IGT,

---

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

0 Answers   iSoft,

---

What should we do to copy the tables, schema and views from one SQL Server to another?

3 Answers  

---