1,060 reputation
415
bio website
location
age
visits member for 2 years, 3 months
seen Jul 9 at 13:58

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
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.
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