What is the difference between cube operator and rollup operator? : SQL Server Architecture

1175

---

What is msdb database? : SQL Server Architecture

1202

---

What is master database? : SQL Server Architecture

1084

---

Explain what are the database objects? : SQL Server Architecture

1146

---

What are pages and extents? : SQL Server Architecture

1073

---

Do you know spatial data types - geometry and geography in sql server 2008?

1092

---

Explain filtered indexes?

1043

---

Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

1033

---

What is inline variable assignment?

1082

---

What is enhanced database mirroring in sql server 2008?

1037

---

Explain encryption of entire databases without the need for application changes in sql server 2008?

1091

---

Explain filtered indexes benefits?

1046

---

What is entity data services?

1117

---

What is plan freezing?

1016

---

Do you know how to store and query spatial data?

1089

---