Reputation
10,023
Top tag
Next privilege 15,000 Rep.
Protect questions
Badges
18 39
Newest
 Good Answer
Impact
~473k people reached

May
23
awarded  Good Answer
May
22
comment SQL actually executed as planned in ORACLE?
@Colin'tHart: I think our two answers are both right from a given point of view. In the short term an plan generated now (as an estimate or when actually running the statements) is likely to be the plan followed when the statements are next run, but over the longer term plans can differ greatly. Query planning is a very complex subject. There are massive books and many research papers written on the subject at various depths if the OP wants to really dig into the area.
May
22
comment SQL actually executed as planned in ORACLE?
@Colin'tHart: could you point to documentation about that? I would be most impressed if it has the intelligence to usefully do when I now have in my head that you mean, and would love to read into the details of how it is achieved.
May
22
revised SQL actually executed as planned in ORACLE?
added 138 characters in body
May
22
revised SQL actually executed as planned in ORACLE?
added 1072 characters in body
May
22
answered SQL actually executed as planned in ORACLE?
May
19
comment SQL Broadband Market Dilemma
"Not sure what that means" - as the reason for closing says, your question is far to broad for here, where questions are expected to be answerable fairly directly and definitely by a few paragraphs (or often a few sentences). What you seem to be needing is a huge piece of business analysis work or vague pointers to help with such an exercise. DBA.SE might be an appropriate place for specific questions about database related details you find confusing in your research, but not your design process as a whole. Unfortunately I'm not aware of anywhere more appropriate of the top of my head.
Apr
29
awarded  Nice Answer
Apr
27
comment Why sharding does not show any improvement?
@thelastblack: you should edit your question to include the extra detail, comments sometimes get cut off (or otherwise ignored) so someone who might otherwise have useful advice may miss the relevance and skip on by without knowing they can help.
Apr
27
answered Why sharding does not show any improvement?
Apr
21
answered How to get a surrogate key value in order to put a foreign key in and create relationship?
Apr
15
comment Restoring a backup of a database from SQL Server 2014 into SQL Server 2012
@BuahahaXD: No, even with a "back dated" compatibility level setting the database structures will be those of SQL2014. The compatibility modes only affect certain behaviour, not the underlying structure.
Apr
14
comment conversion failed when converting the varchar value 'JENNIFER FALCONER
... and the definition of the tables (and other structure like views) involved otherwise we have to guess datatypes which is significant in cases like this.
Apr
9
awarded  Nice Answer
Apr
2
comment MySQL Data Synchronisation from different Databases in C#
That's why I used a comment: I've suggested an alternative rather than answering the actual question! If the result wanted is "an updated copy of the DB from <source> to exist at <destination>" then replication will achieve that as efficiently as anything hand-rolled (unless you have some business logic that states not all tables are to be included in which case a hand-rolled routine may transfer much less). You can do log shipping and control when log backups are taken & shipped & restored so you can have a static copy at a particular time rather than having to run fully dynamic replication.
Apr
2
comment MySQL Data Synchronisation from different Databases in C#
That won't be "integrity safe" unless you completely lock all tables in the source database to stop changes while you make the updates in the destination. Rather then reinventing the wheel you could use existing technology to keep databases in sync and try the built-in replication support: dev.mysql.com/doc/refman/5.0/en/replication.html
Apr
1
reviewed Edit The Local Security Authority cannot be contacted
Apr
1
revised The Local Security Authority cannot be contacted
edit text and improved tagging
Mar
25
answered Recommended number of index for a table
Mar
24
revised High Availability using SQL Server 2012 requires how many licenses
added 42 characters in body