1,100 reputation
415
bio website
location
age
visits member for 2 years, 7 months
seen Nov 13 at 19:30

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?
Apr
8
answered Implementing voting system like reddit/StackExchange?
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
answered MySQL: Use Sysbench on Windows
Mar
25
revised How to use keys in a table so two columns are unique
Answered additional questions per comment.
Mar
25
answered MySQL: SLEEP injection
Mar
25
answered How to use keys in a table so two columns are unique
Mar
11
awarded  Popular Question
Feb
21
awarded  Necromancer
Jan
15
awarded  Popular Question
Sep
16
awarded  Popular Question
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"?
Jul
8
answered Why would SET ARITHABORT ON dramatically speed up a query?
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
accepted Errors keeping stored procedures through restore from backup
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.