Viewing 15 posts - 1,531 through 1,545 (of 6,676 total)
You cannot utilize the Enterprise scale-out feature on a Standard instance - but, there is nothing that I am aware of that requires the databases to be hosted on Enterprise...
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 10, 2020 at 8:00 pm
You can use this site: https://www.brentozar.com/pastetheplan/instructions/
I find it is much easier than having the .sqlplan posted here.
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 9, 2020 at 8:14 pm
How does the EXE return these two variables values in Powershell? Can you show the Powershell commands that you are using to get these variables?
Generally - executing a process (Process.Start)...
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 9, 2020 at 8:03 pm
What is the Powershell script doing - could it be changed to a script task using C#? Maybe you can use a script task and the something like the following? Jeffrey Williams ― Charles R. Swindoll How to post questions to get better answers faster
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
Managing Transaction Logs
November 8, 2020 at 4:46 pm
You missed the point. The stored procedure would be called from a trigger on the table.
The stored procedure would generate the function and the function would be hard-coded based on...
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 7, 2020 at 8:12 pm
It all depends on the SAN though - so check with the storage team on what is available. It may require reconfiguring your instance - as you really do 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
November 7, 2020 at 5:41 pm
Are all of the checks in this test_table based on variables only? If so - you might be able to generate a function based on the values in the table...
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 7, 2020 at 5:19 pm
I would also look at the specific driver you are using - I would expect anything going to RDS has an x64 driver and that is the one you should...
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 4, 2020 at 10:22 pm
You stated you are now getting an error related to a service broker - which means one or more are enabled. And yes, if you have a service broker in...
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 4, 2020 at 10:20 pm
The error that your reported - 1117 - indicates an issue with the I/O subsystem. If that issue has not been corrected it can and will occur again. One of...
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 4, 2020 at 10:14 pm
Thank you. Looking at the databases about three have service broker set as false or 0. Would this be the cause of the message? Also, does it need to...
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 4, 2020 at 8:35 pm
You still need to review the storage system - or this could happen again.
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 4, 2020 at 8:15 pm
Either continue the 'max' out to the maximum number of possible members in a department - or you have to use dynamic SQL to determine the number of maximum members. Jeffrey Williams ― Charles R. Swindoll How to post questions to get better answers faster
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
Managing Transaction Logs
November 2, 2020 at 8:42 pm
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, 2020 at 3:26 pm
This looks like an issue with the internal snapshot that is created for CHECKDB. Since the internal snapshot is created in the same location as the MDF file - 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 30, 2020 at 3:58 pm
Viewing 15 posts - 1,531 through 1,545 (of 6,676 total)