Calendar Tables are only useful if they reflect how your company evaluates its data. Therefore, any company using non-standard financial fiscal years and periods will require customization with their Calendar or Date Table. In this post, I’ll provide an example of how to do so using the M2M ERP System Database. For those who don’t [...]
|
||||||
|
|
What is a Date (Calendar) Table? For the purposes of this article a Date Table is a dedicated table containing a single record for each day in a defined range. They include fields with descriptive attributes for each day such as Year, Month, Week, and whether a particular day is a work day or not. Date [...] SQL Saturday Dallas, which was our third, went off without a hitch. While there were a few items we’ve identified as needing work, overall the event was swimmingly successful. Kevin Kline – Troubleshooting and Performance Tuning Microsoft SQLServer with Dynamic Management Views (DMVs) The festivities started on Friday with our three Pre-Con events. Kevin [...] It’s been a crazy few weeks. As I mentioned previously, I presented at two SQL Saturday Events in back to back weeks. I’m on the core committee for the North Texas SQL Server User Group SQL Saturday, so I was overwhelmed with things to do and couldn’t stop to blog. So, now that I’ve taken [...] I’ll be presenting at two SQL Saturdays back to back. You are taking advantage of SQL Saturday events, right? SQL Saturday Chicago is this weekend (3/26), and I’ll be presenting: Data Warehousing – How to Convince “The Bobs”
I got a meeting with the Bobs in a couple of minutes… Building your first Data Warehouse is [...] “Melodical Murray is a human musical instrument; he makes music by blowing his…blank” – Match Game In the previous article I discussed the issues when working with Null-able fields in Joins and Where clauses. This article will deal with the problems of blank values. What About Blanks? Many systems forego the use of Null-able fields, but [...] This topic has been done to death in many places, but I still get frequent questions about Null field issues in T-SQL. My purpose in this article is not to debate the definition of Null. Smarter men than I have already done so. SQL Server Books Online indicates “A value of NULL indicates that the [...] I’m sorry that my posts haven’t been as regular as I’d like, but the good news is that we’re making great progress with the M-Data Analytics open source project. In order to provide the best benefit to my fellow Made2Manage users, please answer the following questions. What Version(s) of [...] Note: This is the last in a series of five “lessons” which I created for SQL University on the topics of Dimensional Modeling and Data Warehousing. Click here to read the rest of the series. I can haz assimilation? We are Borg – Bringing it all together. Now that we understand the basics of Dimension and [...] Note: This is the fourth in a series of five “lessons” which I created for SQL University on the topics of Dimensional Modeling and Data Warehousing. Click here to read the rest of the series. So, we’ve covered dimension tables and how they give your data meaning. That begs the question, how do we actually [...] |
|||||
|
Copyright © 2012 Made2Mentor - All Rights Reserved |
||||||
Popular Articles