meta user
network profile
| bio | website | |
|---|---|---|
| location | Austin, TX | |
| age | 31 | |
| visits | member for | 2 years |
| seen | May 19 at 11:36 | |
| stats | profile views | 49 |
|
2d |
awarded | Yearling |
|
May 22 |
awarded | Popular Question |
|
May 20 |
awarded | Popular Question |
|
May 17 |
comment |
Database design: Two 1 to many relationships to the same table How is option #1 impossible? The word "Corporation" basically means "a business which is legally a person," after all. Call it a Customers table. |
|
May 16 |
comment |
How to import a varbinary(max) column with bulk import? Which one? If "0x00" is what works for you, then it seems some setting differs between our setups. If "00" is what works for you, and "0x00" does not, then we're both seeing the same thing, and it might make sense to edit your answer. |
|
May 15 |
comment |
How to import a varbinary(max) column with bulk import? Have you used this successfully? On my end, I got "type mismatch" errors until I dropped the hex prefix. "0102" was OK, "0x0101" was not. Perhaps there is a setting somewhere which specifies which method is required. |
|
May 13 |
awarded | Nice Question |
|
May 10 |
comment |
notes / description string in another table in a relational database The duplicate records arose because the notes table did not have uniqueness enforced where it should. That's a simple problem to fix, independently of whether it makes sense to horizontally partition the table at all. I'd say "don't" until and unless it causes a demonstrable performance problem. Start simple, get fancy only if you must. |
|
May 10 |
answered | Can a surrogate key and a primary key be in the same table? |
|
May 3 |
comment |
How can I copy a user while preserving all privs? @NathanJolly: Indeed, if I do need to swap it over rather than testing in parallel, those will make it much simpler. Thanks! |
|
May 3 |
asked | How can I copy a user while preserving all privs? |
|
Apr 26 |
comment |
In Excel 2007-2010, how does one “attach” or “glue” or “stick” information in one cell to information in another cell? P.S., an example or two would probably help clarify your question. Good luck! |
|
Apr 26 |
comment |
In Excel 2007-2010, how does one “attach” or “glue” or “stick” information in one cell to information in another cell? It sounds like a VLOOKUP() and concatenation would do it. However, Excel questions really don't belong on dba.stackexchange.com; MS Office questions generally fit best on superuser.com. |
|
Apr 25 |
accepted | What options exist for copying data between servers on a regular basis? |
|
Apr 24 |
awarded | Tumbleweed |
|
Apr 19 |
comment |
Landed as BI, but databases are a big WTF, what to do? @SQLRockstar: That sounds like a good answer for this question. Perhaps with a few notes about how to help management in prioritizing the fixes, as it sounds like they may not know. |
|
Apr 17 |
asked | What's the proper term for the diverse systems to which a DW connects? |
|
Apr 17 |
answered | MySQL: Join one Row in a table with two Rows in other table |
|
Apr 17 |
comment |
MySQL: Join one Row in a table with two Rows in other table So a user can have multiple logins? From a design standpoint, created_by really should point to users.user_id, rather than a text field. |
|
Apr 17 |
awarded | Citizen Patrol |
