Viewing 15 posts - 46 through 60 (of 245 total)
https://support.microsoft.com/en-us/help/307487/how-to-shrink-the-tempdb-database-in-sql-server
CHECKPOINT;
GO
-- Clean all buffers and caches
DBCC DROPCLEANBUFFERS;
DBCC FREEPROCCACHE;
DBCC FREESYSTEMCACHE('ALL');
DBCC FREESESSIONCACHE;
GO
-- Now shrink the file to your desired size
December 4, 2017 at 4:28 am
I usually use SSIS to run weekly to copy over new Logins @serverlevel and copy over all jobs, as jobs can be altered on a regular basis on the PRIMARY....
September 18, 2017 at 2:05 am
Operating System 5 Error is a windows permissions error. You need to resolve this or it won't work whatever you do in SQL.
Yo may need to detatch the...
September 6, 2017 at 2:00 am
https://www.linkedin.com/in/duffybob/
Can't find it but he is on linkedin.
September 1, 2017 at 8:11 am
Is this for INSERT Operations you are seeing this issue.
If so from the top of my head Bob Duffy @sqlbits gives an example of more cores for...
September 1, 2017 at 7:51 am
Hi Sue
from my understanding, He wants to view all the events and not the SSIS ones. I don't use this every day but doesn't it just filter on...
September 1, 2017 at 7:49 am
Powershell might be your best bet to view the log and omit the event ID where it triggers an information message for the package or packages. Doesn't resolve the issue...
September 1, 2017 at 2:41 am
Hi,
Why would you want to stop this from logging to the APPLICATION LOG. Is it causing an issue.
It is just logging the execution of some SSIS package. May...
August 31, 2017 at 4:09 am
What if SSRS is load balanced across 2 SSRS servers with one SSRS REPORTSERVER DB on a seperate SQL server.
Will backing up on one of the SSRS servers...
August 22, 2017 at 8:18 am
I have skim read this post. So have not fully read all posts.
But you might want to explore Ghost Cleanups in AOAG. Long read operations on the secondaries...
August 22, 2017 at 7:32 am
August 18, 2017 at 7:00 am
I would normally associate APPDOMAIN errors with memory problems.
August 18, 2017 at 3:50 am
Is node 3 the DR server?
August 16, 2017 at 8:28 am
Make sure the PRIMARY is not set to AUTO FAILOVER if that is to be rebooted.
Which one of the 3 is inaccesssible.
August 16, 2017 at 6:20 am
Viewing 15 posts - 46 through 60 (of 245 total)