Answer Posted / guest

experience

What is the maximum size of column in sql server?

502

---

What are the different editions available in sql server 2000?

582

---

Explain system functions or built-in functions? What are different types of system functions?

558

---

How can you control the amount of free space in your index pages?

604

---

What do you understand by intent locks?

568

---

---

Define magic tables in sql server?

562

---

Do you know what is xpath?

551

---

What is database dimension? : sql server analysis services, ssas

612

---

What method is used by the Command classes to execute SQL statements that return single values?

594

---

What is exporting and importing utility?

603

---

Explain time data type in sal server 2008?

543

---

What happens if null values are involved in comparison operations?

537

---

When columns are added to existing tables, what do they initially contain?

623

---

How are the unique and primary key constraints different?

558

---

Why I have to use stored procedures?

586

---