Making a superb coffee wending machine is great and we can write volumes on how to use it. Trust me, it wouldnt appeal if you dont quickly write about any feature of the machine that solves a day to day problem for a coffee drinker / Seller. This is exactly what this write up on the wizard is about. Creation of staging table is about dealing with lots of TSQL. The complexity of creating a staging table is linearly , or sometimes exponentially proportional to the complexity of the parent table. This wizard will help you generate this T-SQL just 5 clicks away from start. Read ahead ...
Hold on, What is a staging table?
Large tables are partitioned for both access and storage performance. Sql Server supports horizontal slicing of data in a table based on a partitioning key column. It so happens that, for a sliding window scenario to work , you need to effectively switch in and switch out data. This is the operation where you need a staging table. Assume you have a sales table , partitioned on a monthly basis. The user wants to move the data for January out of the table and move in the data for the month of may into the table. In order to achieve this the user needs a table which
The above described table is called a staging table. The figure below will explain the details.
Ah, Now I get it ! Ok, I can't wait to know how the wizard helps me create the staging table?
Ok, Here is how you do it.
Will write more on sliding window scenarios in the future blogs and how this wizard will help you achieve the same. It is adviced you read the books online in MSDN on this wizard. It has a clear UI driven flow explained. That is the reason , I have refrained from putting more screen shots. See you soon! Oh forgot, its bright and sunny even today , and I can see the katmai ice shine across Alaska.
PingBack from http://msft.starsports.info/msft/the-wizards-wand-to-partitioning-creating-staging-tables/