Viewing 15 posts - 1,351 through 1,365 (of 49,571 total)
DBO gives full rights on a database, so you can do anything in that database, it does not give rights to the server as a whole.
Running queries are server-level,...
June 2, 2017 at 12:39 am
jasona.work - Thursday, June 1, 2017 2:11 PM(beyond the obvious if you used something like TXT)
I've done that. SQL didn't care
(to be...
June 1, 2017 at 2:26 pm
June 1, 2017 at 1:45 pm
I give up.
Firstly, those are all also useless waits, so get Glenn Berry's *latest* script, not one that's probably from 2005 looking at the excluded waits.
Second....
June 1, 2017 at 1:27 pm
Just use the first part of it, there's no need for the complex portion.
SELECT
wait_type,
wait_time_ms / 1000.0 AS WaitS,
(wait_time_ms - signal_wait_time_ms)...
June 1, 2017 at 7:14 am
June 1, 2017 at 2:16 am
June 1, 2017 at 2:13 am
Are you trying to move the files of the log shipping primary (where the log backups are taken), or the secondary (where the log backups are restored)?
If the...
May 31, 2017 at 2:32 pm
WebTechie - Wednesday, May 31, 2017 1:03 PMHowever, why does the CPUTime and DISKio keep increasing?
Because the CPU and DiskIO are cumulative,...
May 31, 2017 at 2:29 pm
May 31, 2017 at 2:16 pm
May 31, 2017 at 8:35 am
May 31, 2017 at 8:33 am
May 31, 2017 at 3:44 am
May 31, 2017 at 3:42 am
pranabpal - Wednesday, May 31, 2017 1:16 AMWhat wait type is causing the problem . What is solution for this?
I don't...
May 31, 2017 at 3:40 am
Viewing 15 posts - 1,351 through 1,365 (of 49,571 total)