What happens when converting big values to integers?

0 Answers  

---

What are mdf,ndf,ldf files and how to see the data in those files?

6 Answers   Accenture,

---

Can a database be shrunk to 0 bytes, if not, why?

0 Answers  

---

Explain the xml support sql server extends?

0 Answers  

---

Explain what is raid and what are different types of raid levels?

0 Answers  

---

How to swap the data of two columns in a table. both the columns containing varchar values.

9 Answers  

---

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

0 Answers  

---

what is the difference between group and having give an example with query and sample output

7 Answers  

---

What is the difference between two queries: 1. SELECT * FROM table WHERE 1=1; 2. SELECT * FROM table

17 Answers   HP,

---

What are different types of join?

0 Answers  

---

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

0 Answers  

---

internal language used in sql server 2000?

2 Answers  

---