The call to MICROSOFT is FREE OF COST...under MS policy, SUPPORT for SECURITY UPDATES is at NO COST...make sure you let them know this, also make sure you installed it...

The security update requires it to be installed with the 'sa' account for it to be successful. Once that is done, reboot the system and go to services and check...

The update I ran is this:

Update dbo.ReportblCust

Set ValidMsgDisp = ReportblCust.ValidMsgDisp

From

ReportData_DPS.dbo.ReportblCust Join

ReportData_DPSTest.dbo.ReportblCust On

...

I ran this replacing the table and db names with the ones i have on the destination database. It says 20 rows affected but does not reflect those changes on...

how would an update be on the PK column? Will my life be easier if I use DTS and copy the table, the data in it is static so we'll...

But the Developers don't know to backup a table before doing an update. Also at my place the developer didn't make the update statement as part of the transaction and...

Ahh..looks as it I just wasted a topic. I am done with the Indexing, took like 30 seconds only..Thanks anyways!!

The title name should have been 'Time to Create Index'...I guess that was a typo..:P

REBUILD LIKE THIS:

DBCC DBREINDEX(tblName,'Index Names ',Fill Factor)

If you want to Reindex all the tables and on all the indexes use this:

exec sp_MSForEachTable '

print ''?''

DBCC DBREINDEX(''?'')

print ''-----------------------------------------------------------------''

'

Fill Factor: Ideally it should...

Thanks Steve, I ran it a while ago. The available space is now shown at 784 MB.

Gail, thank to you too..

Can I do it during the normal workload or is it to be done during off peak hours?

Thanks for your help..

GilaMonster (11/13/2008)

How do you propose...

Place the tempdb on the RIAD 1+0 to increase throughput. Then the data files on RAID 1+0 also. The backups can go to RAID 5.

Thanks!!

I don't think it is...

But your logical scan fragmentation is low which is good. Also the page density, aka Fill Factor is high which is good too.

How about updating the statistics with full scan??...