1,115 reputation
415
bio website
location
age
visits member for 2 years, 8 months
seen Dec 15 at 15:17

May
13
comment What is meant by DDBB?
That is, it seems to be used as synonym for "database": bit.ly/1mlbSYJ bit.ly/1sIaNwd bit.ly/1oo62Z1 bit.ly/1gyUmuI One commonality is that those using the term do not seem to be native English speakers, so perhaps DDBB is used in one or more other languages.
May
13
comment What is meant by DDBB?
I understand the criticism, but I think @ddaniel is correct. I had never seen this term before, but in searching on it, everywhere it shows up in the context of databases, it seems to be used as synonym for DDBB. stackoverflow.com/questions/4603215/600-tables-in-ddbb
May
9
comment Host is not allowed to connect to MySQL
You need to make sure the combination of your user, password, and host (which ought to be localhost, per @Seti) somehow gets into the mysql grant tables. Whether that is accomplished through a control panel, or by submitting a request to the hosting provider, is something we can't answer for you. You need to contact your host. See dev.mysql.com/doc/refman/5.6/en/grant-table-structure.html to see how the MySQL privilege system works.
May
8
comment Host is not allowed to connect to MySQL
You say that the username and password in your code are "absolutely and precisely 100% correct". Where did you specify them for the mysql server? Did you have someone at the hosting company add them, or do you have a control panel of some sort so that you can add them yourself?
May
6
comment How to speed up looped INSERT INTO statements?
You need to replace this RBAR approach with a set-based solution if you can--you're doing 10,000 individual inserts, and that's going to cost you. What's in the cursor?
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.
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.