Forum Replies Created

Viewing 15 posts - 241 through 255 (of 496 total)

  • RE: Finding lost or forgotten SQL Servers

    Of course, all of the solutions listed assume that you have a domain admin-level account that can go out and do this searching. If you work in a locked...

  • RE: Dating for DBAs - a second date

    Duncan Pryde (4/13/2011)


    bitbucket-25253 (4/13/2011)


    A good question. As of 9:20 AM only 28 percent correct answers.

    Your QOD has achieved one of the major objectives ... teaching

    Thanks -...

  • RE: Dating for DBAs - a second date

    Carlo Romagnano (4/13/2011)


    Thank you very much for this beautiful qotd.

    It's unbelievable, but true, only new types DATE and DATETIME2 work in any case.

    Which is exactly why I got this right...

  • RE: Length

    Guys, I think we all know that the question as originally posted is FUBAR. We know Steve will fix it and points returned. Let's all calm down and...

  • RE: Foreign Keys

    Hugo Kornelis (4/5/2011)


    Funny - I take some things I know so for granted that I don't even consider it might not be as elementary for others.

    In this case, it was...

  • RE: SQL Server 2008 R2 Features

    Dave62 (3/14/2011)


    A while ago I implemented an SQL Server job that uses 7zip to compress backups after they run. I've been getting between 80 and 85 % compression.

    When we upgrade...

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (2/10/2011)


    It's scary when Gail has to qualify her work in South Africa as "Yes, we really do have technology." 😀

    You have a nice voice, Gail.

    Sort of the...

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (2/9/2011)


    GilaMonster (2/8/2011)


    Craig Farrell (2/8/2011)


    LOL! True enough, Saint Gail, Patron Saint of the "Oh Crap, my drives just died!"

    LoL.

    On that topic, who's joining me tomorrow night? http://www.quest.com/backstage/pow.aspx

    Oh,...

  • RE: Connection Problems

    RichB (2/7/2011)


    Ah, not the missing option of 'wtf are you using sql logins in production for anyway?'

    What with them being inherently, disgracefully insecure.

    For anyone that hasn't I strongly recommend using...

  • RE: Are the posted questions getting worse?

    ALZDBA (2/7/2011)


    jeff.mason (2/7/2011)


    ...

    As for karaoke -- the less said the better. 15 DBAs doing Bohemian Rhapsody was too much.

    Your Youtube ref is missing :w00t::hehe::-D

    Dear Lord, I HOPE that...

  • RE: Are the posted questions getting worse?

    Grant Fritchey (2/6/2011)


    I'm sorry I missed Friday night. I would have loved to have hung out with you guys. Jeff's fun when you get him going. SQL Saturday in Cleveland...

  • RE: Connection Problems

    I knew exactly what the problem was and could not find sp_change_users_login, so I read the answers to decide which tried to do the same thing and got it correct....

  • RE: SQL2005 SP4 is here

    Ewan Hampson (12/20/2010)


    What's with the change since the CTP?

    CTP: "Supported Operating Systems:Windows 7;Windows Server 2003;Windows Server 2008;Windows Vista"

    RTM: "Supported Operating Systems:Windows 7;Windows Server 2008;Windows Server 2008 R2;Windows Vista"

    The...

  • RE: T-SQL

    Boy does that question bring back memories. How many here have the scars of activity in 1998 and 1999 for Y2K? I bet any IT professional who had...

  • RE: Unique constraint on a nullable column

    sjimmo (12/2/2010)


    Why would you want to use a where clause to enforce uniqueness? That one stumps me.

    It stumps you because you wouldn't want to do that. Pure and...

Viewing 15 posts - 241 through 255 (of 496 total)