Recently I worked on a project where every data type was user defined. In case you weren’t aware, SQL Server supports the use of User Defined Data Types. These are custom data types which are based on the standard types. For example, if your data always uses a two character string for states, you may [...]
|
||||||
|
|
While troubleshooting an existing 2008 R2 package the other day I received the following error. Error HRESULT E_FAIL has been returned from a call to a COM component. The error occurred when I was using breakpoints and watch windows to diagnose problems in the package. The breakpoint behavior was off because even when there wasn’t a [...] The Problem When you pass GetDate() as a parameter to a stored procedure, the following error is returned: EXEC dbo.ProcDate GetDate() Msg 102, Level 15, State 1, Line 1 When I ran into this problem, I found this helpful article which suggests that I should assign the value of GetDate() to variable and then pass [...] In a previous article, I listed the benefits of using a dedicated date table and included a customizable script which enables you to quickly create your own version. One of my readers pointed out that he uses the date datatype, rather than using the smart integer key method, when working with SQL 2008+ databases. The [...] Last week PASS announced that Dallas and the North Texas SQL Server User Group have been awarded SQLRally 2012. This is great news for all of the nearby PASS User Groups and DBA’s. We’ve put on three successful SQL Saturday events in 18 months, and I’m proud to have been on the planning [...] Every Kimball Group book I’ve read, as well as every Data Warehouse class I’ve attended, has indicated that a Date Dimension Primary Key should be a smart integer key in the format YYYYMMDD (20110518) so I’ve always built my Date tables that way. However, Barnaby (Blog/Twitter) pointed out that I should be using a Date [...] 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 [...] 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 [...] |
|
||||
|
Copyright © 2012 Made2Mentor - All Rights Reserved |
||||||
Popular Articles