Tag Info

New answers tagged

0

The basic question I ask to myself or the user when I gather the requirements in order to create a model and solve your doubt is "How much information do we want to keep about this now and if it is possible to foresee, in the future?" If it is incidental information and you will not need to store much about it apart from the name, maybe you can keep it as ...


3

The short answer: Can't tell. Not enough info. The long answer... If your data is growing at 10%/month, it will be about a year before it is 64/24 times as big. So if you grow the RAM and the buffer_pool by 64/24, you are somewhat likely to have the same cache performance of the buffer_pool. After only one year. The 99% utilized doesn't really say ...


2

Converting comment to an answer. This is not my area of expertise, but you might look at Dennes Torres Simple Talk post from January 2015 for any takeaways that help you. https://www.simple-talk.com/sql/database-administration/centralize-your-database-monitoring-process/ Two subheadings of particular interest may be: Configure Data Collector through ...


2

For advertising purposes, you could use the term "Business data enhancement engineering"? :-) Personally, I would call what you do "[complex] [business] data processing". Thanks. Any suggestion on what terms I should be googling for if I want to find new tools for our processes? Just various combinations of what you already do - etl/data ...


0

To answer at least some of this: Area codes do cross state boundaries in rare cases. There is a tiny bit of the Oregon 541 area code that is shared with California: https://en.wikipedia.org/wiki/Area_codes_541_and_458 Zip codes do very rarely cross state boundaries, or have really odd zip code assignments compared to their geographical assignments. One ...


1

To make gender a freestanding "dimension" is, more likely than not, an attempt to normalize your dimensional model. Unless you have attributes associated with gender then how is it a dimension? Is it possible to have a conformed gender dimension? As for diagnosis are you modeling the process or the values? Very different requirements and issues to deal ...



Top 50 recent answers are included