Viewing 15 posts - 391 through 405 (of 6,676 total)
It's just a filter:
WHERE getdate() >= glfStartDate AND getdate() <= glfEndDate
This won't work with GETDATE() because of the included time. You either need to convert getdate()...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
November 3, 2022 at 9:38 pm
Start with the original source system - either implement daily full backups with frequent transaction log backups, or switch the database recovery model to simple and only schedule...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
November 3, 2022 at 9:25 pm
Start with the original source system - either implement daily full backups with frequent transaction log backups, or switch the database recovery model to simple and only schedule daily full...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
November 2, 2022 at 4:14 pm
Lookup Levenshtein Distance:
https://www.kodyaz.com/articles/fuzzy-string-matching-using-levenshtein-distance-sql-server.aspx
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
November 2, 2022 at 3:59 pm
That is unusual - is there anything specific about that one node that is different than the other servers? I would check the default DNS settings for the server and...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 31, 2022 at 8:21 pm
Not sure I understand the issue - have you removed the user from all databases on the primary (both databases in the AG and those not in the AG) and...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 28, 2022 at 8:48 pm
The advice I have seen is to put the AG into Async mode for the duration of the patching, so that work can continue on the primary while you...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 28, 2022 at 8:41 pm
The simple outline is:
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 27, 2022 at 8:08 pm
You are trying to use 4-part naming to reference the column. That isn't allowed - you need to define an alias for the table and use that alias to reference...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 27, 2022 at 7:11 pm
Is there a way to create this output without using insert into and declaring anything.
Lets forget all the conditions. Lets just say that I need to print this without...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 25, 2022 at 7:08 pm
One of my suggestions in one of the many other threads you have created on this subject was to fix the data. You can write all the code you want...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 16, 2022 at 4:43 pm
I am going to take a guess here - the OP is confusing the host with a guest OS either in Hyper-V or VMWare. That is the only way I...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 9, 2022 at 4:01 pm
Thank you for posting the code - I believe the problem you have is going to be the estimation of rows for the table-valued parameter. You can try modifying the...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 6, 2022 at 9:00 pm
I know this is an old post but wouldn't you want to patch the async secondary availability replica first like Ant-Green suggested? That primary replica regardless of which node...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 5, 2022 at 8:02 pm
Microsoft's recommendations are pretty good, and, I think, based on Jonathan Kehayias' guidance.
So basically - keep it at 8 or lower unless you can specifically identify a scenario...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 5, 2022 at 7:10 pm
Viewing 15 posts - 391 through 405 (of 6,676 total)