Itd under second tab(Optimizations).

From BOL:

Reorganizing the data on the data and index pages by rebuilding indexes with a new fill factor. This ensures that database pages contain an...

SQL Server Integration Services Package Scheduling with SQL Server Agent

http://www.mssqltips.com/tip.asp?tip=1180

The code that I provided is for scheduling ssis package stored in msdb database. Just open Jobs under sql server...

Scheduled SSIS job code:

/SQL "\Package location under msdb folder with its name" /SERVER "SQLInstanceName" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING E

MJ

EG: if the Database is 20GB, reduce the auto grow to 5% from 10% so the Db grows 1GB at a stretch...

Rather than adopting the above methos try specifying autogrowth...

Did you run DBCC CHECKDB with DATA_PURITY command

after the upgrade?

http://www.mssqltips.com/tip.asp?tip=1119

MJ

To test the performance of existing hardware you can make use of sqliostress utility.

http://support.microsoft.com/kb/231619

For server consolidation search in sqlservercentral forums and you will find some really gud information.

MJ

Now what you are telling is that I should script out permissions of bob on dbo.test (does by default BOB has create table permission for dbo schema ? No...

Read "Permissions to Copy the Files" at

http://support.microsoft.com/kb/274463

HTH!

MJ

Following is an example of ALTER SCHEMA command

ALTER SCHEMA

siteadmin —Target Schema

TRANSFER

dbo.testTable –Object to be transferred

Please ensure that you have scripted all the permission of original object before transferring to new...

Run:

sp_changedbowner 'domainA\UserY'

under tht database.

HTH!

MJ

Have you tried running checkdb in that database?

Mj

Restrictions for Point-in-time Recovery

If a log backup taken under the bulk-logged recovery model contains bulk-logged changes, point-in-time recovery is not allowed. Trying to perform point-in-time recovery on a log...

http://support.microsoft.com/kb/263556

You asked this in SQL 2005 forum.

MJ

If he has just copied objects from user database to master database then delete those objects manually and after that make use of shrinkfile command.

MJ

Check indexes fragmentation and make sure statistics are updated.

MJ