Here is a script I found on SQLDusty’s blog on how to populate a Date dimension.
I am re-posting this script here so I can have access to it at any time. Props to Dustin!
?View Code TSQL–Make sure you set the Start and End Date below on row 58 and 59
–Create the tables
Continue reading […] Creating and populating Date dimension in a DW for use in SSAS […]
I usually try to post only technical articles on this blog, especially articles which are related to SQL Server and databases. This one is a bit more general, even though the topic of data warehousing and analysis comes up a few times.
Lately I have been thinking about the social media and its role in our social
Continue reading […] A few words on social media and why it is evil […]
I have a Data Warehouse, in which the data is loaded once a day and during the rest of the time the data does not change.
There are several heavy reports in SSRS used to cater data to the users, and it really saves the day to cache them. The performance improvement is great, but there
Continue reading […] SSRS and report caching, dynamic refresh for Data Warehouses […]