Viewing 15 posts - 8,371 through 8,385 (of 9,244 total)
or just use the stored procedure
sp_chane_users_login
to resync the server login and database user
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 28, 2009 at 3:32 pm
i assume you mean what are the ideal sizes for the log files?
the answer is how much activity is created against the database?
start off with 10% of database filesize...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 28, 2009 at 3:30 pm
check BOL for full info on how to set this up
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 28, 2009 at 2:21 am
muthuuu (2/24/2009)
I got following message in sql-error log
Configuration option 'max server memory (MB)' changed from 2147483647 to 8192.
Run the RECONFIGURE statement to install.
SQL Server has encountered 1 occurrence(s) of...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 25, 2009 at 6:15 am
i would say if you dont have access to it there is possibly a very good reason
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 23, 2009 at 2:28 pm
do you need to restore the db over the original or restore as another name?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 23, 2009 at 2:25 pm
try a google search and you'll find loads like these
http://www.mssqltips.com/tip.asp?tip=1367
bear in mind if using any scripts that specify rebuild with ONLINE=ON this will only be used if using SQL server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 23, 2009 at 2:21 pm
hawg (2/23/2009)
how I can get it to use more?
increase the load on the server. I would set the min and max memory to be the values you want sql server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 23, 2009 at 2:11 pm
firstly how much RAM does the server have and how many sql instances?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 23, 2009 at 2:06 pm
the index rebuild is bugging out before finishing because it cant complete the task i would think.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 23, 2009 at 1:46 pm
hmm, not what i expected to see. When i carry out index maintenance i always set the recovery to bulk logged and then switch back to full afterwards. Alter and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 23, 2009 at 1:35 pm
what does
exec sp_spaceused 'transactions'
produce
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 23, 2009 at 1:00 pm
Mani (2/23/2009)
Iam using the below script to rebuild/reorganize the indexes in sql server 2005. Iam running this script manually every week by going into each database. But I want create...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 23, 2009 at 12:56 pm
so your sql2000 instance is currently clustered is it?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 22, 2009 at 4:14 am
you could import as legacy but if moving to sql2005 why not re write the package in SSIS
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 22, 2009 at 4:11 am
Viewing 15 posts - 8,371 through 8,385 (of 9,244 total)