meta user
network profile
| bio | website | |
|---|---|---|
| location | ||
| age | 31 | |
| visits | member for | 1 year, 10 months |
| seen | 13 mins ago | |
| stats | profile views | 1 |
|
Mar 21 |
answered | ALTER DATABASE command to set log filegrowth and size? |
|
Mar 8 |
comment |
RSExecRole missing Why you can't create it in reportserver database? Do you get an error? |
|
Feb 28 |
answered | Create procedure in else block on SQL Server |
|
Feb 27 |
comment |
Should I create a separate user table for different web products within the same platform? I never worked with MySQL Cluster, but AFAIK, database sharding is horizontal partitioning (by rows), not vertical (by columns). Therefore, you would still need same database schema on each node. It makes no sense to design database differently to "support sharding". |
|
Feb 26 |
comment |
Should I create a separate user table for different web products within the same platform? 1) I don't see why would this be a problem? With first solution you still need someone to coordinate changes between these tables. 2) Are these tables in the same database? Which RDBMS are you using? But I still don't see the problem with this either. 3) You can have a flag in users table which tells you is that a "normal" user or a recruiter, if that's easier for you. |
|
Feb 26 |
answered | Should I create a separate user table for different web products within the same platform? |
|
Feb 21 |
comment |
SQL services wont start due to incorrect drive letter after windows restore No, it's not. SQL Server install is more than just copying files to E:\Program Files (or whatever path). |
|
Feb 13 |
comment |
SQL Server - Must be first statement in query batch - what and why? Sorry, can't help you with that. These rules are probably something what is a causality of the way the system works, rather than something which is made intentionally. Creating tables has to be supported because you must be able to create temporary tables and manipulate them in a single batch. So, that feature is something you have to "plan for". Adding columns to existing tables in a batch is probably something they chose to skip. But this is just my guess. :) |
|
Feb 13 |
answered | SQL Server - Must be first statement in query batch - what and why? |
|
Feb 7 |
answered | Importing data with a lot of SELECTS during transaction |
|
Feb 6 |
awarded | Supporter |
|
Feb 6 |
awarded | Teacher |
|
Feb 6 |
answered | Using data from other database to populate a new database |
|
Jan 30 |
awarded | Editor |
|
Jan 30 |
revised |
SQL update satement taking a very long time / high disk usage for hours added 340 characters in body |
|
Jan 30 |
comment |
SQL update satement taking a very long time / high disk usage for hours You can post DDL for your tables (including all indexes, constraints, etc.). Maybe there is something slowing down your performance and you are missing that. |
|
Jan 29 |
answered | SQL update satement taking a very long time / high disk usage for hours |
|
Jan 11 |
awarded | Scholar |
|
Jan 11 |
accepted | SQL Server 2008 - get current LOCK_ESCALATION on particular table |
|
Jan 10 |
awarded | Student |
