SQL SERVER – Advantages of Partitioning – Quiz – Puzzle – 30 of 31

The year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There was a constant request from the Community to take the learning of these books to the next level. Here is an article which discusses the Author’s Perspective. Let us see the puzzle of Advantages of Partitioning.

Click here to get free chapters (PDF) in the mailbox

Beyond Relational has come up with a very interesting concept – they have converted a few of the questions from my book into the SQL Quiz. The quiz is indeed focused on my two goals. In addition, it’s going to put the learning of the book to a higher stage. Looking at this novel concept, Vinod Kumar (Co-author) and I have decided to help every participant and reader by giving a few hints and suggestions to solve the quiz.

SQL Quiz

As databases volumes become bigger and bigger, the best way to optimize would be to take the huge problem and break it up into smaller chunks. During a large server deployment, a DBA used this advice; he suggested implementing an extensive partitioning for our transaction tables. In line with this, what are the basics of creating, managing and deploying SQL Server partitioning?

Link to participate in SQL Quiz

Notes of Vinod Kumar

There are several options when it comes to using partitioning concepts inside SQL Server. Here’s a hint: choose and explain what SQL Server introduced and what has been enhanced in SQL Server 2008 version.  In relation to this, can you tell at Aligned Indexes are when it comes to partitioning?

Notes of Pinal Dave

Partitioning is a very old concept, yet it has always been implemented indirectly. I remember during my very early career years, we used to create partitioning using the workaround. When any table gets very huge and has an enormous amount of data into the table, we used to create a new table by means of appending it with _1 or _2 value. After doing that, we created the view on the top of this table and selected the data from it. This way, we had to change a few parts of our code and we had to implement the concept of partitioning right away. Now, in SQL Server, we get the partitioning feature as a native feature, as well as means of getting a cool syntax to populate and remove data.

Additional Notes

SQL Server Interview Questions and Answers ISBN: 1466405643 Page#168-170
Database Table Partitioning Tutorial – How to Horizontal Partition Database Table
White Paper – Partitioned Table and Index Strategies Using SQL Server 2008

Prize

There are exciting prizes awaiting the winners. Click here for Prizes and Frequently Asked Questions.

Link to participate in SQL Quiz

Note: SQL Quiz, winners and prizes are administrated by Beyond Relational. The goal of this blog post is to provide additional learning pointers only.

Reference: Pinal Dave (https://blog.sqlauthority.com)