Viewing 15 posts - 106 through 120 (of 6,676 total)
.
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
March 18, 2024 at 6:24 pm
That cannot happen just because of a network outage - if the configuration was altered and the cluster removed, it was because someone removed it.
I would bet something else 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
March 17, 2024 at 4:13 pm
The first question I have is - what issue are you trying to resolve by rebuilding the indexes on this table?
If the answer has anything to do with performance -...
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
March 16, 2024 at 5:06 pm
I am surprised that no one else answered the original question - and this just evolved into using temp tables and trying to solve the performance issue using a temp...
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
March 16, 2024 at 4:00 pm
Linked servers have several problems - one of the biggest is that SQL Server will often pass the query to the other system with incorrect parameters.
We just ran into this...
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
March 16, 2024 at 3:36 pm
Thumbs up for YYYY-MM-DD, removes needless confusion caused by regional formats of MMDD... or DDMM....
2025-09-06
Better be careful here - if that is a datetime and not datetime2 or date...
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
March 13, 2024 at 7:05 pm
the way it is done, on many companies, is to restore the DB on a PROD server (can be same server as the source if server has the required...
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
March 13, 2024 at 6:17 pm
How - and why - are you deploying from SQL Server to SQL Server?
Instead of trying to extract from SQL Server using SSMS - build the project in VS -...
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
March 12, 2024 at 7:30 pm
Just curious - but you stated you are using SSIS, but here you are using a stored procedure to execute a BULK INSERT?
I have to ask why you decided not...
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
March 11, 2024 at 11:10 pm
FWIW - it isn't necessary to set or change the protection level because deploying to the catalog is going to change it anyways.
See here: https://andyleonard.blog/2018/04/deploying-to-the-ssis-catalog-changes-the-protection-level/
Once 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
March 10, 2024 at 5:14 pm
fair enough, I was being flippant and referring to other free plugins. I looked again and the redgate toolkit is 1300, not 1500. I wouldn't consider that significantly less...
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
March 5, 2024 at 5:56 pm
No - that is not an option for an availability group. It would also negate the HA requirements - since anything with a lag would no longer satisfy high availability.
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
March 1, 2024 at 9:59 pm
Is the ID column the clustered index? If not - then you should change the delete so it is deleting in clustered index order. But - as others have already...
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
February 29, 2024 at 10:50 pm
I would have the Oracle DBA's try to kill the process on their side first.
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
February 24, 2024 at 4:12 pm
Without actually seeing a specific workflow or a more specific example - I would have to say that making any changes to the agent job is the problem. If a...
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
February 24, 2024 at 4:09 pm
Viewing 15 posts - 106 through 120 (of 6,676 total)