Tag Archives: Schema

NULL Management, SPARSE Columns, Vertical partitioning and a query

By | June 23, 2015

When discussing DW design I often take a lot of time to emphasize the impact Nulls have on query performance, aggregations, design, storage and much more. While this is not new to most seasoned DW developers it is often overlooked during the design phase and added at a later point in time mostly after testing… Read More »

IS IT POSSIBLE? Bulk operations in Full recovery model

By | May 15, 2015

Here is the reason I am writing this post As per the above entry from MSDN, there cannot be any minimally logged operations in full recovery mode, which is what I have always understood since full recovery model requires point in time recovery. In order to understand my dilemma we need to first define what… Read More »

Video on how to use Schema Compare Option available in SSDT

By | March 21, 2015

In this video we cover how to use the Schema compare option within MS SQL Server Data Tools the Visual Studio IDE that comes as the replacement for BIDS. The video covers how to create a project followed by making changes and detecting the change and then how to sync or merge the changes. http://youtu.be/rNL3Ieev2CQ… Read More »

Dummy data conundrum- MOCKAROO

By | January 16, 2015

When working with data one of the biggest challenges is data generation. While MS provides some relief for this with data generation plans I have found myself constantly looking for a more realistic dataset. The reason for this is , while SQL may not care if the data actually has some meaning , I as… Read More »

Why I Train

By | August 20, 2014

It is always rewarding to hear back from those who have attended my trainings. Recently I have been getting a lot of emails and face to face meetings from former participants who have taken the time to get back to me I have mentioned one such email below. Hi Jayanth,  This is Raja from Cognizant… Read More »

SSAS: – Date dimension

By | July 28, 2014

In previous posts we have successfully created a simple cube deployed and processed it. In this post we are now going to add one of the most important dimensions that need to be added to any cube. The date dimensions is a table that contains a list of dates that can be used within the… Read More »

SSAS Create a Cube

By | July 26, 2014

Once the data source and the Datasource view have been created the next step will be to create the actual cube. Within BIDs there is a very useful wizard which allows the developer to create the cube in a few simple steps. However as the cube become more complex developers will see that it’s easier… Read More »