Viewing 15 posts - 8,386 through 8,400 (of 9,253 total)
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...
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...
February 23, 2009 at 2:11 pm
firstly how much RAM does the server have and how many sql instances?
February 23, 2009 at 2:06 pm
the index rebuild is bugging out before finishing because it cant complete the task i would think.
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...
February 23, 2009 at 1:35 pm
what does
exec sp_spaceused 'transactions'
produce
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...
February 23, 2009 at 12:56 pm
so your sql2000 instance is currently clustered is it?
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
February 22, 2009 at 4:11 am
read the MS recommendations.
http://support.microsoft.com/kb/280345
certainly no larger than 1GB should be required but recommended is 512MB
February 22, 2009 at 4:00 am
the biggest problem is setting the shared storage and this is what i think most people stumble on. The storage can only be accessed by one VM at a time...
February 20, 2009 at 2:45 pm
Anybody?
February 20, 2009 at 3:52 am
anuragingle (2/19/2009)
I added the user to db_datareader and gave him execute rights on specified sp......... seems to be working
yes it would do, you dont need to give db_datareader and it...
February 20, 2009 at 3:26 am
personally i would use
1. Backup the databases in Sql server 2000.
2. Script the logins,jobs in sql 2000
3. Install sql server 2005, SP3, sqlserver2005_dts.msi
4. Restore the backups in newly installed sql...
February 19, 2009 at 4:54 pm
anuragingle (2/19/2009)
Will stored procedure execution fail if user has only read rights on database?Is it possible to implement this and how?
granting execute on a stored procedure to a user does...
February 19, 2009 at 4:45 pm
Viewing 15 posts - 8,386 through 8,400 (of 9,253 total)