RIL_button( “http://sqlconcept.com/2013/03/21/creating-and-populating-date-dimension-in-a-dw-for-use-in-ssas/”, “Creating and populating Date dimension in a DW for use in SSAS” );
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
Continue reading [...] Creating and populating Date dimension in a DW for use in SSAS [...]
RIL_button( “http://sqlconcept.com/2013/01/01/storage-misconceptions-hard-drives-and-ssds/”, “Storage misconceptions – hard drives and SSDs” );
Here are a few misconceptions about storage which I have come across over the years:
the disk plates are moving faster on the inside that is why it is faster to read.
NO: it actually is more efficient to read the data on the outside part of the
Continue reading [...] Storage misconceptions – hard drives and SSDs [...]
RIL_button( “http://sqlconcept.com/2012/12/25/azure-vs-inhouse-sql-server-the-wiki-project-results/”, “Azure vs. inhouse SQL Server – the Wiki project results” );
As I blogged yesterday, the competition is on: in-house SQL Server vs. Windows Azure.
It does feel like the war of the robots!
Yesterday I started importing the data, and today I have some results.
Here are some notes of the process, though.
As I mentioned,
Continue reading [...] Azure vs. inhouse SQL Server – the Wiki project results [...]