Viewing 15 posts - 31 through 45 (of 6,594 total)
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...
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.
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...
February 29, 2024 at 10:50 pm
I would have the Oracle DBA's try to kill the process on their side first.
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...
February 24, 2024 at 4:09 pm
Thus every row will have this 14 bytes of extra storage , regardless if that row gets updated later?
That extra 14-bytes will be added only when the row is...
February 23, 2024 at 6:10 pm
Are you referring to agent jobs running SSIS packages - and only those types of agent jobs?
If so - why are you manually modifying and running agent jobs in the...
February 23, 2024 at 5:59 pm
Are you sure those 'steps' are running? If they are running through an agent job - verify the agent job is not configured to look for the SSIS package on...
February 23, 2024 at 5:47 pm
I will add a few more points to consider:
February 23, 2024 at 5:44 pm
It depends on how the cluster is configured - and whether or not that witness is needed to maintain quorum. If you are configured as node majority with a witness...
February 21, 2024 at 10:01 pm
One option I have used for these types of requests is an SSRS report. Then give the users access to the report and they can export to whatever format they...
February 21, 2024 at 9:46 pm
I am also curious - is this a situation where you upgraded SQL Server and the vendor has not certified their application for that version? In other words, the vendor...
February 20, 2024 at 7:37 pm
I would reinstall the SSIS extension - the data tools does not contain the SSIS extension.
February 20, 2024 at 7:28 pm
If you need near real-time access to the data for reporting - then your only option is going to be replication. All other options result in a point-in-time solution.
If you...
February 15, 2024 at 9:43 pm
I inherited a turd environment. Many, many years of neglect. All to say that I have no idea why things are set up the way they are. I'm just...
February 13, 2024 at 6:33 pm
Viewing 15 posts - 31 through 45 (of 6,594 total)