Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Ziek's SQL Home

Ezekiel is an IT professional with over ten years experience in building database applications and BI/DW solutions. He holds a BSc Computer Science degree from KNUST, Ghana and a MSc Business IT degree from Kingston Business School, London. He has delivered solutions for the Insurance, Banking, Telecom and Housing Industries and his key expertise include developing Microsoft BI/DW solutions, .NET applications, Business Process Improvement and Project Risk Management. He is a Microsoft Certified Professional - MCTS: Microsoft SQL Server 2005 Implementation and Maintenance.

Archives: May 2012

NVARCHAR(n) Vrs NVARCHAR(max)

These datatypes particularly NVARCHAR(n), have been with us for some time now but having seen some of the confusion around when to use any of these, I feel oblige to share and infact to also learn more from anyone out there.

 

NVARCHAR(n)

This data is used for storing a… Read more

1 comments, 2,766 reads

Posted in Ziek's SQL Home on 28 May 2012

Slowing Changing Dimension (SCD) demystified – Part 3

I am wrapping up this series by finally considering the rarely used type 3 SCD.

( i.e.  in most business scenarios)

Unlike the Type 2 SCD, the type 3 SCD tracks only the current value and the original value of a dimension member.
Two attributes are normally used in designing… Read more

0 comments, 438 reads

Posted in Ziek's SQL Home on 22 May 2012

Slowing Changing Dimension (SCD) demystified – Part 2

In Part 1 of this series, we looked at SCD Type I. We would now look at the SCD Type II.  Let’s assume the table below holds historical info of call plans of a customer in the Telecom industry.

Historical information storage (As a row)

From the table above it… Read more

0 comments, 336 reads

Posted in Ziek's SQL Home on 4 May 2012

Slowing Changing Dimension (SCD) demystified – Part 1

SCD is a basically a concept that explains how historical data/values are stored within a data in a database.
There are three main scenarios namely Type I, Type II and Type III.

In this post, I will be discussing the Type I scenario and I promise to do the part… Read more

0 comments, 305 reads

Posted in Ziek's SQL Home on 3 May 2012