Forum Replies Created

Viewing 15 posts - 27,076 through 27,090 (of 49,552 total)

  • RE: Shrink Database in Simple Recovery Mode

    Brandie Tarvin (3/25/2011)

    For instance, there's no mention of the fact that Transaction Logs have no pages.

    No, but there's nothing that says they do. Read up on architecture of...

    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 25, 2011 at 8:03 am

    #1303613

  • RE: Restore - too recent to apply to the database?

    Lots wrong with that maint plan, but nothing that should be causing this.

    You don't need to rebuild and reorganise indexes. Rebuild does everything reorg does and more. Pick one, drop...

    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 25, 2011 at 7:56 am

    #1303604

  • RE: Are the posted questions getting worse?

    WayneS (3/25/2011)

    Need an app that adds an "unused" folder to your system, takes a screen shot of the desktop, moves all icons to the unused folder, and replaces the background...

    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 25, 2011 at 7:50 am

    #1303600

  • RE: Shrink Database in Simple Recovery Mode

    Brandie Tarvin (3/25/2011)

    To get more input, I #SQLHelp tweeted the question about the transaction log to data file that I'd posted. I got an immediate response that SQL does indeed...

    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 25, 2011 at 7:48 am

    #1303596

  • RE: Trace Table Query

    On SQL 2000 it's in milliseconds

    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 25, 2011 at 7:36 am

    #1303583

  • RE: Indexes not used properly

    Can you post table definitions, index definitions and execution plans? It's hard to picture what's going on from your description.

    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 25, 2011 at 7:35 am

    #1303582

  • RE: Shrink Database in Simple Recovery Mode

    Brandie Tarvin (3/25/2011)

    See, this is where I get lost again. Nobody ever states it outright, and that's what's driving me nuts. Which pages? The pages in the log file 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 25, 2011 at 7:23 am

    #1303569

  • RE: Trace Table Query

    ananda.murugesan (3/25/2011)

    Thanks for reply--

    Group by function - need to specify for all select column..

    You're not doing any form of aggregation, so the group by is completely unnecessary.

    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 25, 2011 at 7:17 am

    #1303560

  • RE: Are the posted questions getting worse?

    Fal (3/25/2011)

    GilaMonster (3/25/2011)

    Gianluca Sartori (3/25/2011)

    Couldn't resist....

    AHHHHHHH!!!!! You beat me of a couple of seconds!!!

    That's cause I cheated. Hit quote and post, then went back and added something meaningful. 😀

    You know,...

    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 25, 2011 at 6:58 am

    #1303539

  • RE: Shrink Database in Simple Recovery Mode

    Brandie Tarvin (3/25/2011)

    GilaMonster (3/25/2011)

    The changed records can have long since being written to stable media by the time the associated log records are truncated. Depends what else is happening, what...

    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 25, 2011 at 6:37 am

    #1303523

  • RE: Are the posted questions getting worse?

    Roy Ernest (3/25/2011)

    I think there is a good present that we would like to have. Your upcoming BOOK. 🙂

    What book? I'm not writing a book. 😀

    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 25, 2011 at 6:13 am

    #1303513

  • RE: Shrink Database in Simple Recovery Mode

    Brandie Tarvin (3/25/2011)

    Okay, been reading up. My cookie analogy is still good if I change the bit about "sticking the data in the data file" to "moving the data to...

    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 25, 2011 at 6:11 am

    #1303512

  • RE: Sql server 2005 Mdf File Shrinking on Windows environment

    Did you look through Books Online? The syntax is clearly documented.

    DBCC SHRINKFILE (1, 8192)

    p.s. I don't memorise infrequently used commands and parameters, I had to check Books Online for that.

    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 25, 2011 at 6:02 am

    #1303506

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (3/25/2011)

    Are you people TRYING to kill my inbox? @=)

    No, but it's an amusing side-project

    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 25, 2011 at 5:57 am

    #1303503

  • RE: SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x59f6e189; actual: 0x59fae189). It occurred during a read of page (1:40) in database ID 22 at offset 0x00000000050000 in file 'd:\data\ms\sample.mdf'

    Ray Mond (3/25/2011)

    Having said that, you might want to check the contents of that page just to find out what exactly it contains e.g.

    It's a page in one of 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 25, 2011 at 5:56 am

    #1303502

Viewing 15 posts - 27,076 through 27,090 (of 49,552 total)