Viewing 15 posts - 8,806 through 8,820 (of 9,248 total)
victor_bosc (10/23/2008)
And, what do you think about only rebuilding indexes once a week?
that is the strategy i employ
October 26, 2008 at 5:13 am
for the SQL2005 box leave IP1, Ip2, IP3 unset. Configure IP All with the port number and leave dynamic blank. Restart the instance
October 24, 2008 at 10:08 am
have you imported the package to the file system or package store on the server
October 24, 2008 at 10:03 am
Roger Abram (10/22/2008)
October 24, 2008 at 5:40 am
victor_bosc (10/22/2008)
The problem is that the optimization job increases too much the log file,
set the recovery mode to bulk logged before the index rebuild and then back to full...
October 23, 2008 at 2:39 pm
check the file and directory exists, if it does exist check the permissions on them 😉
October 23, 2008 at 12:50 pm
check for any 3rd party apps, i have seen something similar to this before
October 23, 2008 at 12:47 pm
oohhh i dunno, add in a couple of LOB columns and you'd be well away LOL
certainly could do with a little huh hum normalisation 😉
October 23, 2008 at 12:38 pm
remember to ensure security permissions are retained on the data folders otherwise the SQL server service may not be able to access the files 😉
October 22, 2008 at 7:09 am
use SQLCMD not OSQL, check BOL for SQLCMD help
October 22, 2008 at 7:01 am
a little bit of de ja vue with this post me thinks 🙂
October 21, 2008 at 1:59 pm
Viewing 15 posts - 8,806 through 8,820 (of 9,248 total)