Viewing 15 posts - 1,036 through 1,050 (of 2,356 total)
No, the patch will upgrade all instances.
You do realize that 2008 R2 is no longer supported?
October 21, 2019 at 5:28 pm
Simply, when the restore is attempted, there are open connections to the database.
It appears you are attempting to close the connections to the database by setting it to single user,...
October 21, 2019 at 5:27 pm
I'm curious. What was the reason you made this change, and what kind of differences in the results were you expecting?
October 21, 2019 at 5:22 pm
I agree with you, i have seen in the past adding indexes has resolved high CPU Usage. But never came across adding more memory to SQL Server would help...
October 18, 2019 at 6:33 pm
high cpu is most likely missing indexes, causing the cpu to sort. Or a rogue function.
it's not memory
Broad statements such as this may cause more issues than they solve.
October 18, 2019 at 5:42 pm
so other dba looked at disk activity in sentry one and caught we have two controllers, one with 3 disks, the other with 9. This 9 includes drives with...
October 15, 2019 at 8:01 pm
What is the SCSI controller type? Is this the default LSI Logic SAS? If so, you should change it to the VMWare Paravirtual.
You will not be able to simply change...
October 15, 2019 at 6:36 pm
Download and install http://whoisactive.com/
It's far more useful than sp_who2. It will help you pinpoint the specific process that may be causing CPU spikes.
When you say "not much activity", do...
October 15, 2019 at 6:23 pm
Is this a development environment? If it's not, you are likely out of compliance with MS licensing.
Two instances of SQL cannot share the same data and log files. If that's...
October 15, 2019 at 6:03 pm
I asked below questions to MS VL agents, but they redirect me to their reseller such as CDW. I am not sure why reseller should answer licensing questions, not...
October 15, 2019 at 5:53 pm
Sure, it's advisable.
I'm assuming that the reason for this is because the users and passwords have slowly got out to the people who shouldn't have them, or they do not...
October 10, 2019 at 7:02 pm
"Subqueries" and "Dynamic" queries are not necessarily interchangeable.
Can you provide more info? Maybe a code sample?
October 8, 2019 at 6:05 pm
There is a search feature on this site, and by typing in "Restore Database", and then filtering for "scripts", returned this article:
https://www.sqlservercentral.com/scripts/build_restore_script
There are probably more in the list, this...
October 4, 2019 at 1:31 pm
Auto-save. Turn it off, and see what happens.
October 3, 2019 at 3:56 pm
Do you realize that there really is no such thing as a nested transaction in SQL Server? The two inner begin/commit transactions will not be committed until the final commit...
October 2, 2019 at 4:18 pm
Viewing 15 posts - 1,036 through 1,050 (of 2,356 total)