meta user
network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 6 months |
| seen | 5 hours ago | |
| stats | profile views | 26 |
|
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 |
|
Feb 8 |
revised |
Quick way to validate two tables against each other added 611 characters in body |
|
Feb 8 |
awarded | Commentator |
|
Feb 8 |
revised |
Quick way to validate two tables against each other added 4 characters in body |
|
Feb 8 |
comment |
Quick way to validate two tables against each other @AlexKuznetsov Fair enough, although I suspect that the query engine is smart enough to recognize that we're selecting the entire primary key, or may not process the distinct until it has the result set from the EXCEPT statements. I'm actually curious now if it is. It makes more logical sense to be explicit to the RDBMS, though, so I'll update it. |
|
Feb 8 |
answered | Quick way to validate two tables against each other |
