Forum Replies Created

Viewing 15 posts - 33,301 through 33,315 (of 49,552 total)

  • RE: dbintegrity

    dba_neo (3/29/2010)

    gail,i have attached the output to a text file but i dont see any error messages on the outputfile,i have attached a copy of it hear can you 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

    March 29, 2010 at 9:01 am

    #1141490

  • RE: Understanding indexes

    sqlsc-1053844 (3/29/2010)

    In addition to running regular checks on fragment levels, I check to see what suggestions SQL comes up with. One suggestion in particular has me perplexed. The suggestion is...

    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

    March 29, 2010 at 8:58 am

    #1141489

  • RE: Are the posted questions getting worse?

    Jack Corbett (3/29/2010)

    ... but the time change and amount of natural light has little to do with how well I function prior to finishing my coffee and 10am arriving.

    So glad...

    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

    March 29, 2010 at 8:55 am

    #1141485

  • RE: Full Backup duration conflicting with Transactional Log back up schedule

    On SQL 2005/2008, log backups will successfully run while the full backup is running.

    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

    March 29, 2010 at 8:55 am

    #1141484

  • RE: SQL 2005 - MDF deleted LOG file available

    Only if the database is in full recovery model, there have been no log backups since the February backup (or if there have, you have them), the log has not...

    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

    March 29, 2010 at 8:52 am

    #1141478

  • RE: Database in Suspect Mode

    chowdary.gb (3/29/2010)

    EXEC sp_resetstatus 'yourDBname';

    ALTER DATABASE yourDBname SET EMERGENCY

    DBCC checkdb('yourDBname')

    ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE

    DBCC CheckDB ('yourDBname', REPAIR_ALLOW_DATA_LOSS)

    ALTER DATABASE yourDBname SET MULTI_USER

    No! No! No!

    That is the last resort for...

    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

    March 29, 2010 at 8:50 am

    #1141476

  • RE: How to get rowid in sql server 2005

    Paul White NZ (3/29/2010)

    GilaMonster (3/29/2010)

    The row locator is technically (refer to what Bob posted) the RID on a heap and the cluster (plus uniqueifier if necessary) on a cluster

    So now...

    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

    March 29, 2010 at 3:02 am

    #1141262

  • RE: How to get rowid in sql server 2005

    Paul White NZ (3/28/2010)

    GilaMonster (3/28/2010)

    No, I meant RID. The binary combination of File ID, Page No and Slot index is generally referred to as the Record ID, Row ID or...

    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

    March 29, 2010 at 2:25 am

    #1141248

  • RE: How to get rowid in sql server 2005

    Paul White NZ (3/28/2010)

    GilaMonster (3/28/2010)

    SwePeso (3/28/2010)

    All records do have a "hidden" record identifier, when there is not primary key on the table.

    I assume you mean 'clustered index', not 'primary key'.

    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

    March 28, 2010 at 11:06 am

    #1141115

  • RE: How to get rowid in sql server 2005

    Garadin (3/28/2010)

    My gut was telling me that was the case, but my google skills apparently failed me. I couldn't find anything on it. Anyone have a link?

    http://sqlskills.com/BLOGS/PAUL/post/SQL-Server-2008-New-(undocumented)-physical-row-locator-function.aspx

    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

    March 28, 2010 at 10:07 am

    #1141107

  • RE: How to get rowid in sql server 2005

    SwePeso (3/28/2010)

    All records do have a "hidden" record identifier, when there is not primary key on the table. That's the way SQL Server distinguishes between two identical records.

    I assume you...

    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

    March 28, 2010 at 9:55 am

    #1141103

  • RE: How to get rowid in sql server 2005

    Lynn Pettis (3/28/2010)

    Is it actually a row identifier, like this is row 10? Reason I ask is that is what most people are looking for when they are asking...

    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

    March 28, 2010 at 9:53 am

    #1141102

  • RE: Pls advise on query.. many thanks!!

    wilmoslee 83606 (3/28/2010)

    hi.. really no one can help?? 🙁

    This is a forum, not a chat room. Be patient. Expecting someone to attend to your query in an hour over a...

    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

    March 28, 2010 at 2:56 am

    #1141046

  • RE: Problem with create a new log file in a database in simple recovery mode with device is full

    There's a backup, restore or similar operation running on that database already. Also the source of the log reuse message.

    Can you query sys.dm_exec_requests and see what's running on that database?

    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

    March 28, 2010 at 2:55 am

    #1141045

  • RE: dbintegrity

    RBarryYoung (3/27/2010)

    The involvement of ServiceBroker seems particularly odd to me. Are you perhaps using Database Mirroring?

    That's normal. On 2008 (and 2005 iirc), when CheckDB is run and the NO_INFOMSG...

    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

    March 27, 2010 at 1:55 pm

    #1140979

Viewing 15 posts - 33,301 through 33,315 (of 49,552 total)