Viewing 15 posts - 601 through 615 (of 2,897 total)
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
I notice now, a week later, Task Manager only shows SQLSERVR.EXE using 105 meg. I was expecting it to be much higher. Yet I still get errors trying...
November 18, 2013 at 4:55 am
Viewing 15 posts - 601 through 615 (of 2,897 total)