What is the difference between dropping a database and taking a database offline?

0 Answers  

---

How do I open a .db file?

0 Answers  

---

How to get max 100 values from sql server

7 Answers  

---

How do you find the number of rows in a table?

7 Answers  

---

We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

0 Answers   Amdocs, Apps Associates,

---

---

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 is sql server agent and what are the two modes of authentication in sql server?

0 Answers  

---

How many types of TRIGGERS are there in MS SQL Server?

8 Answers   CarrizalSoft Technologies, TCS, United Healthcare,

---

How can we improve performance by using SQL Server profiler?

0 Answers   QuestPond,

---

How do you start single user mode in clustered installations?

0 Answers  

---

How global temporary tables are represented and its scope?

0 Answers  

---

Explain the different index configurations a table can have?

0 Answers  

---