Answer Posted / a

int

Do you know what are pages and extents? : SQL Server Architecture

550

---

Can group functions be mixed with non-group selection fields in ms sql server?

545

---

Where cross join is used?

519

---

How can you append an identity column to a temporary table?

451

---

What is normalization and denormalization in sql server?

539

---

---

State the difference between union and union all?

521

---

can you instantiate a com object by using t-sql? : Sql server database administration

521

---

What is the importance of three tier architecture?

609

---

What is the main purpose of having conversation group?

498

---

Does sql server 2000 full-text search support clustering?

507

---

How does the report manager work in SSRS?

116

---

What is the maximum size of a dimension? : sql server analysis services, ssas

562

---

What is Replication?

634

---

How to sort the query output with order by clauses in ms sql server?

636

---

Where is localdb stored?

559

---