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

1172

---

What is msdb database? : SQL Server Architecture

1198

---

What is master database? : SQL Server Architecture

1081

---

Explain what are the database objects? : SQL Server Architecture

1143

---

What are pages and extents? : SQL Server Architecture

1071

---

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

1090

---

Explain filtered indexes?

1041

---

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

1030

---

What is inline variable assignment?

1082

---

What is enhanced database mirroring in sql server 2008?

1034

---

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

1090

---

Explain filtered indexes benefits?

1042

---

What is entity data services?

1115

---

What is plan freezing?

1012

---

Do you know how to store and query spatial data?

1087

---