How to count groups returned with the group by clause in ms sql server?

0 Answers  

---

What is the difference between clustered and non-clustered indexes in ms sql server?

0 Answers  

---

What are the features of Embedded SQL

0 Answers   HCL,

---

what is the system function to get the current user's user id? : Sql server database administration

0 Answers  

---

Do you know sql server 2008 introduces automatic auditing?

0 Answers  

---

---

How can I track the changes or identify the latest insert-update-delete from a table?

0 Answers  

---

What do we need queues in sql service broker?

0 Answers  

---

What is Online Index Rebuild Operation?

1 Answers  

---

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,

---

how to get 25th row in any table in sqlserver can u tell me syntax

8 Answers  

---

What is the impact on other user sessions when creating indexes?

0 Answers  

---

What do you mean by normalisation?

0 Answers  

---