Subscribe to this blog
Sam Vanga's SQL
Archives: January 2013
Script to Populate Date Dimension, without Using a Cursor
Most of the scripts I've used to populate date dimension uses a cursor. Since data is loaded only once to a date dimension in the ETL life cycle, using a cursor isn't a sin.
Still, when I was reviewing my own code the other day, I wanted to get rid… Read more
0 comments, 613 reads
Posted in Sam Vanga's SQL on 22 January 2013
Script to Populate Date Dimension, without Using a Cursor
Most of the scripts I’ve used to populate date dimension uses a cursor. Since data is loaded only once to a date dimension in the ETL life cycle, using a cursor isn’t a sin.
Still, when I was reviewing my own code the other day, I wanted to get rid… Read more
0 comments, 28 reads
Posted in Sam Vanga's SQL on 22 January 2013
SQL Server Views
This post is first of yet to come long series on basic concepts of SQL Server. I’ll begin with basic 101 introduction to SQL Server views. I wouldn’t recommend reading any further if you are an experienced sql server’er. I value your time
What are views?
- virtual tables
- named select…
0 comments, 246 reads
Posted in Sam Vanga's SQL on 22 January 2013
Scripts to Detect Data Warehouse Issues
Standards and best practices are like flu shots you take before you’re infected; Database best practices protect your databases from bad things. But, we all make mistakes. It could be because we’re on a time crunch, or we’re lazy (which I’m guilty of by the way), or maybe it’s part… Read more
2 comments, 20 reads
Posted in Sam Vanga's SQL on 15 January 2013
Scripts to Detect Data Warehouse Issues
Standards and best practices are like flu shots you take before you're infected; Database best practices protect your databases from bad things. But, we all make mistakes. It could be because we're on a time crunch, or we're lazy (which I'm guilty of by the way), or maybe it's part… Read more
0 comments, 84 reads
Posted in Sam Vanga's SQL on 15 January 2013