SQL Server Performance

Search Results

Search Again
  1. jinugeorge05

    Stats out of date

    Thread by: jinugeorge05, Oct 25, 2007, 4 replies, in forum: SQL Server 2005 Performance Tuning for DBAs
    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...
  2. jinugeorge05

    Rename a database

    Thread by: jinugeorge05, Oct 17, 2007, 5 replies, in forum: SQL Server 2005 General DBA Questions
    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....
  3. jinugeorge05

    Renaming data files in 2005

    Thread by: jinugeorge05, Oct 17, 2007, 8 replies, in forum: SQL Server 2005 General DBA Questions
    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?...
  4. jinugeorge05

    What happens behind the log file screen??

    Thread by: jinugeorge05, Sep 12, 2007, 4 replies, in forum: SQL Server 2005 General DBA Questions
    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...
Showing results 1 to 4 of 4
Search Again