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

  • 0 posts edited
  • 0 helpful flags
  • 13 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.
Jan
18
comment SQL Server AG - Is there any case for un-clustering prior to certain operations?
No I don't. What I want to know is if I do an operation that takes 5 minutes on a non clustered database, will the same take 10 minutes in a cluster, or the same amount + some minimal overhead? I'm guessing it's not going to double or even get that close, but I was hoping for some experienced insight.
Jan
18
comment SQL Server AG - Is there any case for un-clustering prior to certain operations?
But it only waits for a write to the secondary node's log. If there's an alter on a large table, it shouldn't wait for the alter to complete on the secondary, correct?
Jan
18
comment SQL Server AG - Is there any case for un-clustering prior to certain operations?
this is synchronous
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?