Viewing 15 posts - 8,791 through 8,805 (of 9,241 total)
my thoughts exactly
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 27, 2008 at 12:30 pm
depends on the referential integrity of the tables, etc. Do you want to import data such as key id fields?
disable any constraints and import the data then re enable them
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 27, 2008 at 11:32 am
michael.anyone (10/26/2008)
allocated as 100GB file but having only 20GB inside
first thing i would do Michael is ascertain just how much disk space the live database requires.
Once this is done shrink...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 27, 2008 at 11:29 am
choose the correct recovery model for your database and backup accordingly
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 27, 2008 at 11:20 am
dont forget to run dbcc updateusage against each database and rebuild the indexes too
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 27, 2008 at 11:17 am
GilaMonster (10/26/2008)
There's no direct way to query the filesystem.
i would say this is best done through the web pages code
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 26, 2008 at 12:32 pm
memory support in the main, 64 bit has better support for larger memory configs
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 26, 2008 at 12:21 pm
fivetenmm (10/24/2008)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 26, 2008 at 9:01 am
victor_bosc (10/23/2008)
And, what do you think about only rebuilding indexes once a week?
that is the strategy i employ
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 26, 2008 at 5:13 am
your welcome
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 25, 2008 at 6:20 am
for the SQL2005 box leave IP1, Ip2, IP3 unset. Configure IP All with the port number and leave dynamic blank. Restart the instance
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 24, 2008 at 10:08 am
have you imported the package to the file system or package store on the server
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 24, 2008 at 10:03 am
Roger Abram (10/22/2008)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 23, 2008 at 2:39 pm
WMI would be my preference
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 23, 2008 at 1:02 pm
Viewing 15 posts - 8,791 through 8,805 (of 9,241 total)