|
||||||
 |
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 [...]  (No Ratings Yet)If you give a rating less than the maximum, you must leave a comment with suggestions on how to improve the post. :)  Loading ...
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 [...]   (4 votes, average: 4.50 out of 5)If you gave a rating less than the maximum, you must leave a comment with suggestions on how to improve the post. :) Loading ...
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. The Hardware: As I mentioned, Continue reading [...] Azure vs. inhouse SQL Server – the Wiki project results [...] (1 votes, average: 5.00 out of 5)If you gave a rating less than the maximum, you must leave a comment with suggestions on how to improve the post. :) Loading ...
|
|
||||
|
Copyright © 2013 sqlconcept.com - All Rights Reserved Powered by Good Will. (Will is the person who offers his sympathy to others together with ideas, but who does not give any guarantee about the completeness of the concepts or the immaculate perfection of the scripts on this site. Use this site to grasp SQL Server concepts and to get knowledge. ) |
||||||
