how to control the amount of free space in your index pages? : Sql server database administration

0 Answers  

---

How to modify the underlying query of an existing view?

0 Answers  

---

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

0 Answers  

---

Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

0 Answers  

---

How will u test the stroded procedures and functions? difference between SP and Triggers

2 Answers   TCS,

---

What are the events recorded in a transaction log?

0 Answers  

---

What is the difference between windows authentication and sql server authentication

7 Answers   HCL,

---

What is the fastest way to permanently delete a 1 million row table named customers?

0 Answers  

---

select top 5 * from emp order by newid() my question is , how this query get executed?

5 Answers  

---

What happens when unicode strings concatenate with non-unicode strings?

0 Answers  

---

How can I tell if sql server is 32 or 64 bit?

0 Answers  

---

what purpose does OPENXML clause have in sql server stored procedure?

1 Answers  

---