What is index, cluster index and nonclustered index?

0 Answers  

---

when we use function instead of procedure? plz tell me the situation with ex?

3 Answers   IBM,

---

Which command displays the SQL command in the SQL buffer, and then executes it?

3 Answers   TCS,

---

What are the different Authentication modes in SQL Server and how can you change authentication mode?

0 Answers  

---

Explain the basic concepts of SQL server architecture?

2 Answers   College School Exams Tests,

---

---

how to find nth highest salary

103 Answers   Cognizant, IBM, NexGen, Oracle,

---

What is data compression? : sql server database administration

0 Answers  

---

What is the diffrence between update_one and auto_fix?

3 Answers   IBM,

---

SQL stops working in every 15 days displaying message that database log file is full. Log file size is 3.95 GB. It is happening after shrinking the database also. What is solution to overcome this problem. Please help me as it's urgent.

5 Answers  

---

What is a trigger and its types?

0 Answers  

---

How to check what was the last restore transaction LSN on Log-Shipping and Mirroring when we doesn't have a Monitor server and Witness server?

2 Answers   IBM,

---

How to get the number of affected rows?

0 Answers  

---