Forum Replies Created

Viewing 15 posts - 30,091 through 30,105 (of 49,552 total)

  • RE: BACKUP WITH NORECOVERY

    SQL* (10/8/2010)

    thanks for your reply, but i'm not able to understand what exactly it will do?

    It will backup the database and then change the database state from ONLINE to RESTORING....

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 9, 2010 at 2:07 am

    #1234593

  • RE: Common questions asked in SQL Server DBA Interview

    Please note, resurrected year-old thread.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 8, 2010 at 1:37 pm

    #1234498

  • RE: General Question on Indexes and their Stats

    gregory.anderson (10/8/2010)

    Question, is the index "worthwhile" if there are only scans? I'm guessing that's a relative question, but just in case...

    Maybe. Index scans are going to be cheaper than table...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 8, 2010 at 12:19 pm

    #1234443

  • RE: Clustering and SQL recovery mode

    Check with them that their SAN backup solution is supported by SQL (typically will hook into SQL to freeze the IOs during the snapshot). Otherwise when it shapshots the datab...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 8, 2010 at 12:08 pm

    #1234436

  • RE: How do I create an ID to read a Log Shipped database (read only)

    Create the user on the primary. When you create the login on the secondary, make sure that the SID matches with the login on the primary.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 8, 2010 at 12:06 pm

    #1234435

  • RE: How to kill Rollback process

    homebrew01 (10/8/2010)

    Gedas (10/8/2010)

    You can kill rollback only by doing that but you must have latest backup:

    1. stop SQL engine

    2. delete db and tlog files

    3. start SQL engine

    4. delete db

    5....

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 8, 2010 at 10:59 am

    #1234391

  • RE: Avg. Index Fragmentation % Still the Same after Maintenance

    Way, way, way too small to worry about.

    Under 24 pages, an index rebuild will likely do nothing at all. It's generally considered that 1000 pages should be about the point...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 8, 2010 at 10:59 am

    #1234390

  • RE: How to truncate log file in SQL Server 2005

    Brandie Tarvin (10/8/2010)

    Be aware that just typing in CHECKPOINT and executing it does not mean that it will execute immediately. SQL Server will run it immediately only if it's convenient...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 8, 2010 at 6:55 am

    #1234212

  • RE: Index Statistics Look Improper

    I suggest you add some print statements to that code and make sure that it really is doing all the tables as it should be.

    Print the table name, print the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 8, 2010 at 6:49 am

    #1234203

  • RE: Index Statistics Look Improper

    Should work. You've checked that the script is actually running to completion? You're not shrinking the DB at all?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 8, 2010 at 4:46 am

    #1234143

  • RE: Avg. Index Fragmentation % Still the Same after Maintenance

    How big is the index? How many pages.

    Update stats has nothing to do with index fragmentation, so running a stats update won't do a thing to the index fragmentation stats.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 8, 2010 at 4:29 am

    #1234137

  • RE: Index Statistics Look Improper

    The stats are not wrong.

    Likely the index is too small to benefit from reindexing. How many pages does it have?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 8, 2010 at 4:27 am

    #1234136

  • RE: Index Statistics Look Improper

    Index 0 is the heap. Heaps don't have names. Hence the column for index name is null (and that's not the same query you ran earlier)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 8, 2010 at 4:26 am

    #1234134

  • RE: Index Statistics Look Improper

    I suspect you ran that in a database other than dbname, so the Object_id returned null, hence you got stats for all tables.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 8, 2010 at 4:21 am

    #1234130

  • RE: Request for health check Script

    Please be more specific as to what you want. What do you mean by 'health check'?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 8, 2010 at 4:20 am

    #1234129

Viewing 15 posts - 30,091 through 30,105 (of 49,552 total)