Answer Posted / s. raban

see my answers

What are key constraints?

520

---

What is the correct order of the logical query processing phases?

532

---

What is faster join or union?

608

---

Can an entity have two primary keys?

535

---

How to select true false based on column value in sql server?

514

---

---

‘Order by’ is not allowed in a view how can you sort information from a view?

589

---

What xml support does the sql server extend?

541

---

How do you troubleshoot errors in a SQL Server Agent Job?

566

---

How does normalization work?

512

---

Does partitioning improve performance sql server?

498

---

what is the primary use of the model database? : Sql server administration

516

---

Explain a checkpoint?

542

---

1 01 101 01010

1576

---

What is mscorsvw.exe - process - microsoft .net framework ngen?

535

---

What does this statement do @@rowcount?

558

---