Viewing 15 posts - 601 through 615 (of 2,898 total)
1 level of improvement is to display the job list in the "Object Explorer" pane, highlight all the jobs at once, then "Create to File" and put them all in...
November 24, 2013 at 10:51 am
I set -g256 on a test box and was able to run my update using linked server. I may try a smaller number, then consider making the change on production....
November 23, 2013 at 7:44 pm
GilaMonster (11/21/2013)
Why don't you download a trial, play with it for 14 days and decide for yourself if it's worth buying after that time?
This.
In addition "worth" is different for different...
November 22, 2013 at 1:13 pm
Jeff Moden (11/21/2013)
Oracle765 (11/21/2013)
thanks again grasshopperI have done that and it works perfect
your a star much appreciated
DO NOT IMPLEMENT THAT DYNAMIC CODE! It probably doesn't need to be dynamic...
November 22, 2013 at 6:44 am
USE Database_WithBigLog
DBCC OPENTRAN
November 22, 2013 at 3:43 am
Are they all the same versions of SQL on the different servers ?
You can restore a 2005 backup to 2008, but not 2008 to 2005.
November 21, 2013 at 5:32 am
How frequent are your transaction log backups ? The more frequent, the less it will grow.
November 20, 2013 at 12:50 pm
How frequently do your transaction log backups run ?
Is the failure random ? Same time every day ?
When it fails, is the DB full or simple ?
November 20, 2013 at 12:41 pm
Is another process also setting it to simple ? It should be left in full all the time.
November 20, 2013 at 11:43 am
Hoooboy ....
Why do you feel the need to shrink the log file ?
What if you have a disaster at 11 am, and need to restore your database to 10:59 am...
November 20, 2013 at 11:38 am
I should have more clearly said that /PAE was already in the boot.ini, configured by my predecessor.
My goal is to make best use of the 4 G ram that I...
November 18, 2013 at 8:11 pm
Perry Whittle (11/18/2013)
homebrew01 (11/18/2013)
Perhaps tomorrow I will reduce SQL RAM to 2.5 G, and add the -g700 setting, then restart.
If you dont have AWE enabled correctly and you set the...
November 18, 2013 at 10:52 am
The Performance book mentioned earlier (page 136-137), and this site it pointed me to
http://msdn.microsoft.com/en-us/library/bb613473(v=vs.85).aspx
Say I should set /3GB in the boot.ini (Windows Server 2003, 32 bit, 4...
November 18, 2013 at 5:38 am
Perhaps tomorrow I will reduce SQL RAM to 2.5 G, and add the -g700 setting, then restart.
November 18, 2013 at 5:29 am
Not sure if I'm reading it correctly
"Total Server Memory (kb)" shows a flatline at "100" in the graph. The "last", "avg", "min" and "max" boxes all show 3.2 G.
That...
November 18, 2013 at 5:11 am
Viewing 15 posts - 601 through 615 (of 2,898 total)