What is the maximum rows in sql server table?

0 Answers  

---

How important do you consider cursors or while loops for a transactional database?

0 Answers  

---

Where do you find the default Index fill factor and how to change it?

0 Answers  

---

how do we find every fifth record in a table

14 Answers   Aspire, HCL,

---

List the various tools available for performance tuning?

0 Answers  

---

but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration

0 Answers  

---

what is the signification difference of this bit data type between sql 6.5 and later version sql server?

1 Answers  

---

1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.

12 Answers   Accenture,

---

What are the events recorded in a transaction log?

0 Answers  

---

Explain sql server service broker?

0 Answers  

---

What happens when transaction log is full?

0 Answers  

---

Can a stored procedure call itself(recursive). If yes what level and can it be controlled.?

2 Answers  

---