Forum Replies Created

Viewing 15 posts - 14,911 through 14,925 (of 39,970 total)

  • RE: Add a default to a column

    Yes, and Yes. We want to expand and cover things that are in BOL in a different way. A practical use for this in a short article that someone has...

  • RE: Import Wizard

    Feel free. Submit a draft using the "Write for Us" link on the left.

  • RE: Fantasy Football 2011

    Ray K (11/29/2011)


    WOO-HOO!!!!!!!

    I clinched a playoff berth!!! :w00t::hehe:

    *** breaks out champagne bottles and sprays them around the locker room! ***

    Congrats, I think I just clinched up πŸ™

  • RE: Enable autogrowth for databases in SQL Server

    I tend to agree with Bruce that Powershell is a nice multi-server tool. It's easily deployable to multiple machines, and it allows you to potentially do things that are harder...

  • RE: Thinking Time

    sturner (11/29/2011)


    Thinking time is important, but only by half. The other half is actually documenting the results of your thinking processes along with any conclusions you came up with.

    too true....

  • RE: NOT able to defragment using Index Rebuild

    Second vote for the SQLFool script.

    Small tables don't defragment well because there just isn't enough extents/pages. Once they grow and you start to get hundreds or thousands of pages, fragmentation...

  • RE: delete in batch makes drive space almost full

    If it's just log backup space, then I'd do this:

    1. Switch to simple mode

    2. Delete in batches

    3. Switch back

    4. Take diff backup

    5. Start log backups again

    This seems to be...

  • RE: Truncation warnings

    I think LEN is a holdover from the other languages where that's a common function. Not sure when DATALENGTH was introduced (it's in 2000), but it might also be legacy...

  • RE: delete in batch makes drive space almost full

    I'm confused. What space are you trying to save? You started posting as though you were having log space issues with this delete. Then you stated you kept two weeks...

  • RE: Creating an user as a record in users table vs. creating an actual user?

    It's not trusting the client, but having a way to trace the data in the DMVs or Extended Events to a specific client when there's an issue.

    You won't want to...

  • RE: Stress – It’s Not Fair

    Stress can be very hard to deal with, especially when it comes from friction between teams. I've tried to be more efficient at work, but also do a professional job....

  • RE: Stress – It’s Not Fair

    TravisDBA (11/28/2011)


    WolforthJ (11/28/2011)


    The chart went up in the break room, so everyone saw it when a project was behind and knew which team caused it. After a while we...

  • RE: delete in batch makes drive space almost full

    If you aren't overly worried about recovery, then switch to simple, and delete in batches, which will limit log file size. Then switch back to full, make a full backup,...

  • RE: delete in batch makes drive space almost full

    You can do that, but make a full backup after getting back to full so you can keep your recovery chain intact.

    You can batch delete, and run log backups as...

  • RE: Enable autogrowth for databases in SQL Server

    Bruce,

    My apologies if it seemed that I was complaining. I thought you had a nice script there and a great start. I wanted the OP to think it through a...

Viewing 15 posts - 14,911 through 14,925 (of 39,970 total)