Forum Replies Created

Viewing 15 posts - 26,386 through 26,400 (of 49,552 total)

  • RE: Database design document

    Grant Fritchey (5/2/2011)

    GilaMonster (5/2/2011)

    Please note: 4 year old thread

    That's weird. It popped up on my RSS feed. I should only see new posts. I didn't even bother to check.

    SSIS Guy...

    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

    May 2, 2011 at 3:42 pm

    #1318782

  • RE: Documenting database

    Please note: 8 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

    May 2, 2011 at 3:40 pm

    #1318778

  • RE: Database design document

    Please note: 4 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

    May 2, 2011 at 3:36 pm

    #1318773

  • RE: Are the posted questions getting worse?

    I hate trying to work out pre-requisites for sessions...

    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

    May 2, 2011 at 3:35 pm

    #1318771

  • RE: Are the posted questions getting worse?

    Grant Fritchey (5/2/2011)

    GilaMonster (5/2/2011)

    Grant Fritchey (5/2/2011)

    Red Gate Absolutely ROCKS!

    Sledgehammers are great for dealing with rocks.

    Ah well, so much for attempting to be irrelevant on The Thread.

    Nah, that's what I...

    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

    May 2, 2011 at 3:33 pm

    #1318768

  • RE: Are the posted questions getting worse?

    Grant Fritchey (5/2/2011)

    Steve Jones - SSC Editor (5/2/2011)

    Brandie Tarvin (5/2/2011)

    GAH!

    I have a lot of love for Brian Knight and Pragmatic Works (his company), but I'm about to throw stones at...

    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

    May 2, 2011 at 3:09 pm

    #1318756

  • RE: index file size got changed

    SQLMyFriend (5/2/2011)

    Thanks, this is an index file, does it make difference?

    Nope. The only thing that shrinks database files is a shrinkdatabase or a shrinkfile

    The only thing I suspect is we...

    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

    May 2, 2011 at 1:54 pm

    #1318705

  • RE: Are the posted questions getting worse?

    [Jim].[dba].[Murphy] (5/2/2011)

    I understand 'the last one' (after BI) might have a 'M' both before and after the 'C'.

    You know, it just might. 🙂

    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

    May 2, 2011 at 12:40 pm

    #1318662

  • RE: index file size got changed

    Check the jobs for one that shrinks the DB. Nothing other than a shrink will reduce the size of the file.

    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

    May 2, 2011 at 12:38 pm

    #1318661

  • RE: index file size got changed

    Depends on the settings. Unless you run it with NoTruncate is will reduce the size of the file. Still badly fragmenting all your indexes though.

    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

    May 2, 2011 at 11:04 am

    #1318565

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (5/2/2011)

    BTW did you have a chance to tackle my puzzle to get all the prepared plans in the cache (from sp_sprepare)?

    I started on something for that (and cursorfetch), didn't...

    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

    May 2, 2011 at 11:02 am

    #1318562

  • RE: Are the posted questions getting worse?

    [Jim].[dba].[Murphy] (5/2/2011)

    Stefan - that is one reason why I have no certs. I began studying many times from back in the late 90's for an MCSE and MCSD but...

    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

    May 2, 2011 at 11:00 am

    #1318559

  • RE: index file size got changed

    Why?

    You just grew the file, so why shrink it again?

    Have you rebuild all the indexes that the shrink fragmented?

    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

    May 2, 2011 at 10:27 am

    #1318531

  • RE: Are the posted questions getting worse?

    [Jim].[dba].[Murphy] (5/2/2011)

    Since I newer around here, how did you solve this problem in the past? I guess everyone round-robin to take a turn without a dog pile, and deal...

    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

    May 2, 2011 at 10:02 am

    #1318511

  • RE: index file size got changed

    Autoshrink on?

    Manual shrink job?

    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

    May 2, 2011 at 9:49 am

    #1318500

Viewing 15 posts - 26,386 through 26,400 (of 49,552 total)