Viewing 15 posts - 781 through 795 (of 6,678 total)
Heh... Wecome aboard but... "Must Look Eye!"
You've posted what looks like Oracle code in an SQL Server forum and it's not going to work in SQL Server.
On a 6+...
September 21, 2021 at 8:11 pm
Follow question on this as I am not 100% clear on what to do here.
If I restore a 2016 backup to a 2019 server, after the restore, I MUST...
September 20, 2021 at 5:41 pm
I would definitely move the comments column to its own table - with keys to identify when the comment was made and who made the comment. I would also look...
September 20, 2021 at 5:34 pm
If the secondary node was restarted - or unavailable, that would cause the kinds of messages you are seeing. As for the cluster shutting down, it shows that the cluster...
September 20, 2021 at 5:17 pm
Not quite - the transaction log will be truncated after a log backup has occurred *and* there are no open transactions in the previous VLF's. The log also cannot be...
September 20, 2021 at 5:11 pm
Redgate's SQL Search is the best answer - and it is free. If you - for some reason - cannot use that tool then you are going to have to...
September 19, 2021 at 2:05 pm
There is also the schema changes report available - that shows not only changes to tables but will also show changes to any objects and who made the change. However,...
September 15, 2021 at 9:21 pm
Why would you do that? That would just mean rerunning this code over and over until all rows matching the criteria have been deleted. What purpose would that serve?
September 12, 2021 at 2:41 pm
I have already put code in place to block the NULL values for some of the Attributes, not sure why is was ever code to allow those into the...
September 11, 2021 at 4:32 pm
The steps you outlined are correct - that process will allow for patching with minimal interruption.
September 11, 2021 at 3:01 pm
This is a basic template for a batch delete/update/insert process:
Declare @rowsAffected int = 1
, @batchSize int = 50000; --increase/decrease as...
September 10, 2021 at 5:04 pm
What is the purpose of the AG node? I am assuming that the FCI cluster is primary - SERVER3 is an AG secondary, and that secondary is set to asynch...
September 10, 2021 at 4:41 pm
Ola's utility - and many procedures that were built to do the same thing - will have a post-step after an index reorganize that updates the statistics. So either a...
September 7, 2021 at 9:54 pm
That is expected - the /netonly credentials will be used for that connection even though it shows your local windows credentials.
September 7, 2021 at 6:05 pm
Viewing 15 posts - 781 through 795 (of 6,678 total)