Click here to Skip to main content
Click here to Skip to main content
Go to top

SQL Server 2008 Interview Questions and Answers

, 19 Sep 2008
Rate this:
Please Sign up or sign in to vote.
A Big Downloadable List of SQL Server 2008 Questions and Answers

Introduction

An interview is a very important event for any person. A good interview leads to a good career if the candidate is willing to learn. I always enjoy interview question and answer series. This is my very humble attempt to write SQL Server 2008 interview questions and answers. SQL Server is a very large subject and not everything is usually asked in an interview. In an interview, what matters the most is conceptual knowledge and learning attitude. I have listed the entire series in this post so that it can be easily downloaded and used. All the questions are collected and listed in one PDF which is here to download.

If you have any questions or if you want to add to any of the questions, please send me an email or write a comment.

Sample of Questions Specific to SQL Server 2008

What is Data Compression?

In SQL SERVER 2008, Data Compression comes in two flavors:

  • Row Compression
  • Page Compression

Row Compression

Row compression changes the format of physical storage of data. It minimizes the metadata (column information, length, offsets, etc.) associated with each record. Numeric data types and fixed length strings are stored in variable-length storage format, just like Varchar. (Read more in the download)

Page Compression

Page compression allows common data to be shared between rows for a given page. It uses the following techniques to compress data:

  • Row compression
  • Prefix Compression

For every column in a page, duplicate prefixes are identified. These prefixes are saved in compression information headers (CI) which reside after page headers. A reference number is assigned to these prefixes and that reference number is replaced wherever those prefixes are being used.

Dictionary Compression

Dictionary compression searches for duplicate values throughout the page and stores them in CI. The main difference between prefix and dictionary compression is that prefix is only restricted to one column while dictionary is applicable to the complete page.

Reference

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

pinaldave
Founder http://blog.SQLAuthority.com
India India
Pinal Dave is a Microsoft Technology Evangelist (Database and BI). He has written over 2200 articles on the subject on his blog at http://blog.sqlauthority.com. Along with 8+ years of hands on experience he holds a Masters of Science degree and a number of certifications, including MCTS, MCDBA and MCAD (.NET). He is co-author of two SQL Server books - SQL Server Programming, SQL Wait Stats and SQL Server Interview Questions and Answers. Prior to joining Microsoft he was awarded Microsoft MVP award for three continuous years for his contribution in community.
Follow on   Twitter

Comments and Discussions

 
GeneralExcellent Pinmembercdbh19-Sep-08 21:27 
GeneralRe: Excellent Pinmemberpinaldave20-Sep-08 8:21 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web02 | 2.8.140916.1 | Last Updated 20 Sep 2008
Article Copyright 2008 by pinaldave
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid