Viewing 15 posts - 1 through 15 (of 1,416 total)
I am not sure what the question is. Are you wondering if I think SQL Server will work better or if SQL Server will need the same indexes as MySQL...
October 28, 2020 at 9:31 pm
As a thought - if you can translate the symbols to numeric values, you could do it with some messy WHERE clause. What I mean is something like:
October 27, 2020 at 10:09 pm
October 27, 2020 at 10:09 pm
I imagine this depends on your CMS.
But it sounds like a use case for SSIS to me. With SSIS you can have it fire queries against multiple databases simultaneously or...
October 27, 2020 at 4:23 pm
My opinion - you get what you pay for.
The authors of the books need to make money, so they write books on what they know.
If free training is what you...
October 26, 2020 at 5:16 pm
Found this article:
From that link, the solution is to have a better index. Now, that being said, I would expect that since you are doing a SEEK, your...
October 26, 2020 at 5:09 pm
Sounds to me like windows permissions are set wrong. You said you can't access it from Windows run menu OR from SQL Server, this makes sense. If you have no...
October 23, 2020 at 4:12 pm
Have you tried using CAST or CONVERT to pick a data type on the column that has an unknown datatype? Not the best solution, but will solve the problem.
October 23, 2020 at 3:47 pm
Gotta love it when SQL can't guess how long the rollback will take so it tells you 0% and 0 seconds. I've seen that before and there is that panic...
October 23, 2020 at 12:59 pm
Sorry I couldn't be more help, but I am stumped on this one.
I am confident that restarting the SQL Server service will fix the issue, but I am confused why...
October 22, 2020 at 9:54 pm
Well, I'm confused... the query I gave should have shown you the rollback status on the query. Since sysprocesses and sp_who2 are both saying it is rolling back, my next...
October 22, 2020 at 9:20 pm
Since the query didn't return anything, my thought is the rollback completed successfully. Where are you seeing the "killed/rollback" information?
October 22, 2020 at 8:44 pm
I am pretty sure that if the SSIS service is not running, you can't do most SSIS related tasks such as deploying to an SSIS catalog.
I am a little surprised...
October 22, 2020 at 8:23 pm
Our solution is a bit different than yours, but our RTO and RPO drives it differently than yours does.
We used to use maintenance plans, but have switched over to direct...
October 22, 2020 at 8:15 pm
Pretty sure you are just stuck waiting for it to finish rolling back.
Basically, if the query made changes to anything, SQL needs to undo those changes.
I would check the results...
October 22, 2020 at 7:58 pm
To me this sounds like the audit is running as a different account than the backup.
When you create the audit file on the local drive, who is the "owner" of...
October 22, 2020 at 7:39 pm