sreimer

Calgary, Canada

stevenreimer.com

Age: 37

Systems Analyst/Developer currently residing in Calgary, Alberta Canada

Feb
4
accepted SQL Server AG - Is there any case for un-clustering prior to certain operations?
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
25
awarded Scholar
Jan
25
awarded Autobiographer
Jan
25
accepted Editing a Library (App) Template
Jan
25
comment Editing a Library (App) Template
Should I be looking at custom content types instead?
Jan
25
asked Editing a Library (App) Template
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
awarded Editor
Jan
18
revised SQL Server AG - Is there any case for un-clustering prior to certain operations?
more detail
Jan
18
comment SQL Server AG - Is there any case for un-clustering prior to certain operations?
this is synchronous
Jan
18
asked SQL Server AG - Is there any case for un-clustering prior to certain operations?
Dec
11
awarded Tumbleweed
Dec
4
asked Availability Group failover stuck in Resolving State
Dec
1
awarded Enlightened
Dec
1
awarded Nice Answer
Nov
26
awarded Excavator
Nov
26
revised BeginExecuteNonQuery without EndExecuteNonQuery
typo in method name
Nov
17
comment Escape SQL function string parameter within query
Thanks for the additional explanation. I took your advice and removed the function.
1 2 3 4 5