Well, my question (if it were me) Would be "I have this schema post schema and I'm trying to achieve 3NF, but I'm uncertain if I have succeeded. What could I improve to achieve 3NF? Other reviews on how to improve this schema are most welcome!"
@ypercube Pick a suitable model of 1-2 generations ago and do a search on Ebay for it. You'll get best results for ones that are widely used on the corporate lease market - e.g. Thinkpads, Dell E64x0 series.
If you need to, get one with a spinny and buy a third party SSD for it. There's an application on Intel's web site that will clone a disk image onto a SSD.
Intel 525s and 530s on Ebay respectively. Some Dell systems will take mSATA SSDs as well.
That lets you migrate the operating system onto the mSATA SSD and keep data on the spinny that came with the system.
Protip - when looking for ex-lease laptops, keep an eye on the screen resolution of the listing. It's not easy to replace the screen, so make sure you get one with the screen resolution you're after.
@JamesLupolt the day I went to the postgres conference. We went to a pub after the event, and I forgot it when we moved from the pub to a nearby reastaurant
10-15 minutes later, I returned back but it was gone.
We were standing outside, so someone passed by and just took it.
well, there is nothing that important on this machine
ATM I'm not sure which encryption we use but it's definitely not BitLocker
I don't know how Erwin gets to his hundred-year-old answers regularly, but the stubbornness of the OP amazes me
This is what I did and it worked. It did exactly as I wanted. Your attitude in protecting the users from themselves is unappreciated, as is your downvote for what was, in fact, the answer. — Jeremy HolovacsDec 27 '11 at 16:51
Not so short I don't think... The approach this user made on this question "http://stackoverflow.com/questions/20078074/mysql-multi-level-category-structure" for the database structure works fine. However, thinking in a relational database approach, what is the best approach for a multi-level category database?
@dzerow Also check this: Models for hierarchical data. It will give you lots of options for modelling hierarchies, especially given the limitations of MySQL.
I am confused.
Issue: SSIS ("SQL Server Import Export Wizard") should let me build a data import package and save it to a file, for easy re-running (converting to a task, etc.).
I want to save a package, but the tool always tells me "profile cannot be saved because your are not running SQL Sta...
You'd (likely) need to use a Script Component acting as your source which means all the parsing and such is going to be in .NET language of your choice. You'll then be spitting these entities into a dataflow but I assume I can't just shove all the Headers into a table and all the Detail as there's a relationship between the two and in proper fashion, the detail won't have a value linking to the Header because it's implied due to XML nesting/encapsulation
So you then have to do something like add an extra attribute into the Detail output to provide linkage back to the header or ... something else... Maybe flatten header and detail into a single wide row and then a custom proc to save it piecewise