Viewing 15 posts - 1 through 15 (of 295 total)
One thing to keep in mind is that the current DB context specifies whether PARAMETERIZATION is FORCED or SIMPLE. When FORCED, some filtered indexes may be rendered unusable.
July 16, 2020 at 4:34 pm
Thanks, Jeff. Very interesting.
May 28, 2020 at 8:09 pm
I just sync the service master key from the old server to the new one. Simple process: 1) BACKUP SERVICE MASTER KEY TO FILE using some pwd; 2) copy the...
December 12, 2019 at 2:37 pm
I am surprised to see this. Thank you for posting it.
December 10, 2019 at 2:50 pm
Here's one way that requires a temporary 3rd node: add a standalone SQL server; configure new AG between your existing FCI and the standalone; evict one of the FCI nodes...
November 25, 2019 at 6:52 pm
I appreciate you posting this. I reckon the exhibited behavior does make sense, but would not have occurred to me.
November 15, 2019 at 5:01 pm
I also suspect index maintenance. If so, associated LDF growth can be minimized by temporarily changing tlog backup frequency to something very frequent (e.g. 30sec) while index maintenance is running,...
October 25, 2019 at 9:07 pm
I think suspending would not help anyway, just would defer all that work until later (and I think it piles up in the LDF?).
Another way to possibly improve things would...
October 25, 2019 at 9:02 pm
I am not good at this stuff, really not a fan of XML, but here's an example of approach I use. Crude example, but maybe enough to get you started. ...
October 21, 2019 at 3:23 pm
All good replies above. I have never heard of subqueries referred to as dynamic queries.
October 11, 2019 at 2:04 pm
Thoughtful posts like this make me love this site. Thanks, Steve.
September 30, 2019 at 3:08 pm
You're right...changing connection strings is another story. But you should be able to have the AG ready for that during business hrs, whenever you want, with no impact. I can't...
September 26, 2019 at 7:26 pm
JimKern - thanks for posting all the follow-up after answering your own question. good stuff.
September 26, 2019 at 3:57 pm
Are we able to add this database to an AG during business hours? YES. Definitely.
Is there a performance difference between Synchronous and Async? YES. Many people claim it is not...
September 26, 2019 at 3:50 pm
We get these msgs on an AG where the sector sizes ("Bytes Per Physical Sector") are indeed different between datacenters. No easy solution, so we live with it. I have...
August 13, 2019 at 4:15 pm