There are 5 indexes in this table..One Server which is a replica of the problematic server works fine. That has the same frag levels and the table...
I have a pretty huge job which run normally for 1hr max on a SS2000. Lately, after bringing over the database to SS2005,the job goes running over...
Hey Greg, That worked like a charm.Thank you!!
Do you know how to rename a database from 'Testdb' to 'TestDB'? Sp_renamedb doesn't recognize the case difference.It says that the database exists....
Hi Sathya , Reattaching the database was failing when I tried it from the GUI.But when I tried it using the commands, it worked...Thinking about...
Hi Satya, I tried that. - Detach the DB - Renamed the physical files - Attach it back This fails because the sysdatabases still holds the old file...
I am planning to rename the data files using the steps outlined below...Could you let me know if that is the standard way of doing it on 2005?...
I got an explanation for this:Rollback statements are also logged. Each transaction reserves space on the transaction log to ensure enough log space...
Hi Sathya..That was a fast response [:D]Thank you!! I get the point that you are trying to convey,but my question is.. I am not even deleting the...
I have a table,X of size 13GB(Reserved space=Data+Index+Unused Space)(44,245,625 rows) My Transcation Log file is restricted to a growth of 15GB I...
Separate names with a comma.
