Reputation
305
Top tag
Next privilege 500 Rep.
Access review queues
Badges
2 8
Newest
 Editor
Impact
~8k people reached

  • 0 posts edited
  • 0 helpful flags
  • 14 votes cast
Feb
4
comment SQL Server AG - Is there any case for un-clustering prior to certain operations?
This ended up being the real reason. Their script ended up having no determinable impact. It was their unfamiliarity with clusters that made them concerned.
Jul
11
comment Oracle out-of-place upgrade on same host: impdp issues
REMAP_DATAFILE works, I found that solution but it took me a while to get the quoting/delimiting syntax correct. Can you expand on the session variables? I'm also having an issue with roles not importing, seemingly due to the fact that the object already exists.
May
11
comment MySQL Cluster Installation
can you provide your config files?
May
10
comment What is the best database design for this situation?
That adds a bit of complexity. You could have a CreditApprovalDetails table. If you need to link approvals to orders, you would need a join table, unless it's 1:1. However, without a full understanding of your application I can't make an informed suggestion.
Feb
10
comment What is the expected performance impact when dropping a large table
That said, any idea how MySQL will treat handle other queries during the drop? Should I expect issues with connection handling, or just overall slower performance due to increased file IO?