Forum Replies Created

Viewing 15 posts - 76 through 90 (of 206 total)

  • RE: Can't save column type change

    Can you do it in the GUI and rather than apply script out the T-SQL and post it on here along with an overview of the schema of the table...

    Hope this helps,
    Rich

    [p]
    [/p]

  • RE: Managing Transaction Logs

    GilaMonster (10/6/2010)


    RichardDouglas (10/6/2010)


    oh god, great point Gail, you might want to check your index fragmentation too. Paul Randall did a great demo on how shrinking your files causes fragmentation.

    That's only...

    Hope this helps,
    Rich

    [p]
    [/p]

  • RE: Full backup every hour

    marc 96091 (10/6/2010)


    Also, is there anyway to make Tlog backups smaller? When I've run them in the past they've been several gigs for a whole days worth and I...

    Hope this helps,
    Rich

    [p]
    [/p]

  • RE: Managing Transaction Logs

    GilaMonster (10/6/2010)


    RichardDouglas (10/6/2010)


    If you want to add more weight to it talk about management of virtual log files. Google/Bing "VLF" and "SQLSkills". Kimberley and Paul have some great blogs on...

    Hope this helps,
    Rich

    [p]
    [/p]

  • RE: Are the posted questions getting worse?

    GilaMonster (10/6/2010)


    Shawn Melton (10/6/2010)


    I have to ask you Gail (and others that frequent this forum) how the heck do yall move between answering post so quickly? Do you just have...

    Hope this helps,
    Rich

    [p]
    [/p]

  • RE: Managing Transaction Logs

    If you want to add more weight to it talk about management of virtual log files. Google/Bing "VLF" and "SQLSkills". Kimberley and Paul have some great blogs on the subject....

    Hope this helps,
    Rich

    [p]
    [/p]

  • RE: Are the posted questions getting worse?

    My god :pinch: that is some scary stuff.

    Hope this helps,
    Rich

    [p]
    [/p]

  • RE: Statistics

    Hi sorry for the delay and thank you for your reply.

    I'm quite removed from the day to day running of the DWH as things stand but I want to bring...

    Hope this helps,
    Rich

    [p]
    [/p]

  • RE: Race to post 1,000,000

    Just tweeted that SSC's 1 millionth post is imminent, I wonder how that will affect the number of posts coming in.....

    Hope this helps,
    Rich

    [p]
    [/p]

  • RE: Race to post 1,000,000

    Ray K (10/6/2010)


    Are we there yet?

    (And damn! I just noticed my last post netted me 1,000 points! Personal milestone for me!)

    Congratulations, wouldn't it have been cool if your...

    Hope this helps,
    Rich

    [p]
    [/p]

  • RE: Race to post 1,000,000

    Getting close now!

    Hope this helps,
    Rich

    [p]
    [/p]

  • RE: Race to post 1,000,000

    Wow less than 1000 to go. Will be any day now!

    Hope this helps,
    Rich

    [p]
    [/p]

  • RE: Today's Random Word!

    laryngotracheobronchitis

    Hope this helps,
    Rich

    [p]
    [/p]

  • RE: Race to post 1,000,000

    Ninja's_RGR'us (10/5/2010)


    RichardDouglas (10/5/2010)


    Ninja's_RGR'us (10/5/2010)


    I haven't got anything... are they sending mail directly to your box or on the ssc messages center?

    I have a subscription to this thread which will email...

    Hope this helps,
    Rich

    [p]
    [/p]

  • RE: Race to post 1,000,000

    Ninja's_RGR'us (10/5/2010)


    I haven't got anything... are they sending mail directly to your box or on the ssc messages center?

    I have a subscription to this thread which will email me

    Hope this helps,
    Rich

    [p]
    [/p]

Viewing 15 posts - 76 through 90 (of 206 total)