855 reputation
26
bio website
location
age
visits member for 1 years, 5 months
seen yesterday

Apr
16
comment SQL Server 2005 database log size increasing drastically?
@veljasije Full backup doesn't shrink the log, but it does free pages in the existing log for reuse. If you're backing up your transaction logs consistently and see a consistent workload, your log files will not increase in size very often.
Nov
3
awarded  Yearling
Sep
12
awarded  Good Answer
Jul
30
comment Can I use a foreign key index as a shortcut to getting a row count in an INNODB table?
@ypercube Yes, that's why RDBMSs have variable isolation levels and table hints. You can specify NOLOCK to read uncommitted data. This means you can direct the query planner to risk giving you unreliable data in exchange for not locking the database at all. MySQL appears to only support isolation levels, meaning your query would need to set the session isolation level. Probably what OP should actually be using.
Jul
30
revised Can I use a foreign key index as a shortcut to getting a row count in an INNODB table?
added 49 characters in body
Apr
20
answered Relational vs Non-Relational Database for Events Database
Mar
4
comment Unable to restore dump file in mysql5.5
On line 1? Did you dump from a Linux system and are restoring to a Windows one? Do you need to convert line endings? I'm not sure if that matters, but "line 1" seems suspicious. Otherwise, what is on line 1?
Mar
2
revised Separated databases, separeted datas
added 334 characters in body
Mar
2
answered Separated databases, separeted datas
Feb
21
comment Tools and methodologies to keep to DBs aligned
Keep in mind that your options are going to be severely limited if you're using a custom, in-house database. Additionally, it's generally considered best practice for dev and prod to at least use the same systems. Having dev be Postgres but prod be custom-memory.db is a little awkward.
Feb
21
comment Tools and methodologies to keep to DBs aligned
Possible duplicate from SO: stackoverflow.com/questions/175451/…
Feb
19
comment Resetting a SQL Server 2012 sequence
@PaulWhite I would say you shouldn't need to drop and recreate it. Dropping an entire schema just to reset a sequence is a bit severe, and that's my reading what he's doing. I'd be interested in having him try to stop and restart the server after dropping and recreating the sequence and schema to see if that causes the sequence to reset, though. I'm also curious if he's got SP1 applied.
Feb
19
answered Resetting a SQL Server 2012 sequence
Feb
12
comment Open source alternative to SQLMaestro for PostgreSQL
@mbnoimi The point about MySQL Workbench is that you can design the database overall and then create it in PG. It depends on what you want in a designer. If you want something that is completely visual, and will write all the SQL for you, and works on Linux, and supports PostgreSQL, and is currently developed, and is easy to use, and is free... well, you're asking for a lot. You'll have to compromise somewhere.
Feb
10
comment What would cause Mysql database entries to be truncated to 253 characters?
I know historically that inserting a string longer than the size of the field specified in the table definition in MySQL would silently truncate the data and succeed, whereas most normal RDBMSs return an error. What's the table definition you're inserting to? Specifically, what's the column datatype for the field that's being truncated?
Feb
9
comment Quick way to validate two tables against each other
@ErikE True, but that won't be a problem as long as we select the entirety of the primary key.
Feb
8
revised Quick way to validate two tables against each other
added 123 characters in body
Feb
8
revised Quick way to validate two tables against each other
added 556 characters in body
Feb
8
comment Quick way to validate two tables against each other
I don't have two servers to test on. :)
Feb
8
revised Quick way to validate two tables against each other
added 611 characters in body