Viewing 15 posts - 1 through 15 (of 1,341 total)
Getting back to the subject, Ron suggested that I was pretty well set in my opinion and that he wasn't going to try to change my opinion. I'm suggesting that...
February 8, 2024 at 6:27 pm
You may have never seen a good data warehouse. The advantages over standard reporting procedures are significant. Calculations such as YTD, PTYD and the comparisons of the two, rolling averages...
February 8, 2024 at 12:42 am
I have used a similar approach to help show work orders that had been open a long time to stand-out more easily yet more orderly. Worked great.
February 7, 2024 at 3:47 pm
Once you start thinking of a table as singular, your mind shifts to RBAR instead of set thinking.
Totally disagree.
November 17, 2023 at 1:46 pm
If you have the skillset in house, I highly recommend using SSIS. If the skillset is not in house, scripts are probably preferred. But in ETLs of any complexity, they...
October 2, 2023 at 1:18 pm
I use SSMS. My complaints are minor and I've been using it in some form for more than 20 years. I don't want to get used to a new GUI...
September 18, 2023 at 2:36 pm
They’re also a delight to the scientific and other communities because the range of dates (although I believe it uses the wrong calendar prior to the year 1753) has been...
June 22, 2023 at 8:30 pm
I recently added audit triggers that had some degree of complexity. To test the performance one of the developers issued a million inserts in a little over an hour--far beyond...
March 27, 2023 at 1:25 pm
I prefer to use triggers. They do have to be written carefully, but if done properly capture changes well. Nulls are trickier to handle when updating data as they are...
March 27, 2023 at 11:37 am
I started with Kimballs 2nd edition The Data Warehouse Toolkit. Taught me all I needed to know.
March 20, 2023 at 12:59 pm
I've been doing this a long time and I haven't found anything "terrible" about it. When I'm working with other naming conventions it can sometimes be hard to otherwise avoid...
February 8, 2023 at 3:17 pm
I would not prefix a view with tbl. In any case I rarely use views in an OLTP environment. I do make extensive use of them in my OLAP designs...
February 8, 2023 at 2:15 pm
The use of the prefixed "TBL_" is a design error so bad it has a name; it's called the tibble.
This is not a design error. It does not violate the...
February 8, 2023 at 1:24 pm
KpiId (This is a foreign Key to another Dimension Table which explains the name of KPI in question
This is probably not right. Each metric should have its own...
January 6, 2023 at 2:13 pm
Viewing 15 posts - 1 through 15 (of 1,341 total)