920 reputation
315
bio website
location
age
visits member for 1 year, 11 months
seen 1 hour ago

Apr
11
comment What mongodb database layout would fit better
@ypercube: Very true, that was sloppily written on my part. The source there is a MongoDB engineer, and he must be referring to MongoDB itself. The RDBMS world has had years to work on making joins fast, and has been successful at it.
Apr
9
comment What mongodb database layout would fit better
If you're going to downvote an answer, perhaps you could provide a comment as to why. It's helpful for improving answers in the future.
Apr
9
comment What mongodb database layout would fit better
I'm still not clear on what you have in mind by "playlists". Is a playlist just the track listing of an album--the songs on it--or is it a selection of songs from various albums?
Apr
9
comment What mongodb database layout would fit better
Also, ccould you clarify what you mean by "Here I don't know what to do about playlists"? Are you considering storing particular combinations of songs from different albums as though they were albums?
Apr
9
comment What mongodb database layout would fit better
What attributes are you going to record? For example, do you want to store the length of each song on an album? Do you want to store the members of the album's bands?
Mar
31
comment Alphanumeric field in MySQL
"I thought to split the field as 3 different columns" If storing the contract number in three columns is an option, that is the simplest way to do this--one for city code, one for date, and the third auto_increment column.
Mar
28
comment Alphanumeric field in MySQL
Question: Let's say we have one contract with the contract number CBE27032014001. If there is another contract in that city the following day, would the contract number be CBE28032014001 or CBE28032014002? I'm assuming the former.
Mar
27
comment MySQL: Use Sysbench on Windows
I downloaded the tarball and read the README-WIN.txt. It certainly indicates that it can be compiled on Windows using CMake.
Mar
27
comment MySQL: Use Sysbench on Windows
No, I'm not sure. That was actually quite an old article and since then (read the comments) the application has been ported to Windows.
Jul
9
comment Why would SET ARITHABORT ON dramatically speed up a query?
I'm not sure. I wonder if it's simply the case that someone at MSDN ran into a similar situation, set ARTIHABORT to ON, saw the performance improvement, and jumped to same conclusions others have. As far as indexed views and computed columns, I'm unclear. At one point it states that the SET options must have specific values if an INSERT, UPDATE, or DELETE operation modifies data values stored therein. Elsewhere they state that the optimizer will ignore indexes for "any query" that references said indexed view or computed column. Are both true, or is it really "any query modifying data"?
Jun
17
comment Errors keeping stored procedures through restore from backup
Why all the down votes, folks? Too wordy, or what?
Jun
17
comment Errors keeping stored procedures through restore from backup
We decided instead to keep an ALTER PROCEDURE script going with all the changes made to the stored procedures that haven't been pushed live. This runs after the restore of the databases. It's a bit more hands-on than I was hoping for, but it should work. This is basically your idea of using some sort of source control.
Jun
17
comment Errors keeping stored procedures through restore from backup
Thanks for the response. Could you clarify a bit on the concatenation of Unicode and non-Unicode? The dev team has specifically asked for a fresher dataset more frequently. It doesn't have to be every day, though, so I may implement your suggestion of restoring to a different name, and then once a week or so change the names (assuming I don't find the actual problem, which seems increasingly likely).
Jun
17
comment Errors keeping stored procedures through restore from backup
@JonSeigel, I have run the step that generates the CREATE scripts and find no errors in them--but of course there is no guarantee that the script is exactly the same each time.
Apr
16
comment Referencing multiple tables from a single table and store additional data
Do parts and tunings apply to specific cars at specific times? Do certain parts and tunings exist only in certain games, but cars exist across multiple games? I don't fully understand the system you are trying to describe. At first blush it seems like you might want a table that puts together a car with its tunings and parts on a specific date, record that date in TimeSet, and that should handle it. I rather suspect I'm missing something, though.
Apr
3
comment Why should an application not use the sa account
I'd be hesitant to buy anything from a bunch of guys who think it's OK to leave the keys to the kingdom sitting in a config file in plain text. I know it's not your call, but if you can get The Deciders to see what a terrible idea that is, and what it says about the vendor, that might help your case.
Mar
20
comment big db for managing user files and settings
Each file gets a new record added to user_file table. There's no issue with multiple users having files recorded in the same table, because each record has the user's unique ID number in it.
Mar
19
comment Best relational database structure for this data
For something like Word, isn't "execute" a permission? But I see your point if for some reason executing or accessing an application isn't considered a permission.
Mar
19
comment Best relational database structure for this data
Sure, give me a minute or so.
Mar
19
comment big db for managing user files and settings
That is not even close to following to the relational model. If you intend to implement this in MySQL, you certainly aren't going to want millions of tables, all but one of them with one record each. You shouldn't have any issue with the three tables in my answer, each having millions of records each.