Forum Replies Created

Viewing 15 posts - 181 through 195 (of 459 total)

  • RE: Connection pooling troubleshooting in SQL 2008, client unable to reuse a session with SPID...

    Gift Peddie (12/10/2009)


    The error you are getting says two things your databases are in compatibility 80 and your application is also old because this problem is fixed for SQL Server...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

  • RE: Are the posted questions getting worse?

    Kit G (12/10/2009)


    When I lived in LA for 10 years, it was easy to spot the native Angelinos from every one else when it

    a) rained - A few rain...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

  • RE: Are the posted questions getting worse?

    Bru Medishetty (12/10/2009)


    Lynn Pettis (12/10/2009)


    Bru Medishetty (12/10/2009)


    ray 78019 (12/10/2009)


    Hi Greg,

    If I understand correctly, if I open the DTS in SQL Server Management Studio (2005) and save it under a different...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

  • RE: Are the posted questions getting worse?

    jcrawf02 (12/10/2009)


    GabyYYZ (12/10/2009)


    -3C/27F here (-12C/11F with wind chill)...uggh...

    My vacation may not be much warmer, heading to Amsterdam to visit family for Christmas, it's a bit warmer than Toronto, but way...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

  • RE: Are the posted questions getting worse?

    -3C/27F here (-12C/11F with wind chill)...uggh...

    My vacation may not be much warmer, heading to Amsterdam to visit family for Christmas, it's a bit warmer than Toronto, but way windier and...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

  • RE: Are the posted questions getting worse?

    And now for something completely different, a coworker, non-DBA, forwarded me this link. I thought it was a hilarious Dilbert: http://www.dilbert.com/strips/comic/2009-11-01/%5B/url%5D

    Edit: Fixed hyperlink

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

  • RE: Some good tips on projecting database growth?

    Thanks folks, will trust the data then. Regarding backup sizes, I'll have to modify that as some of our backups are compressed, but otherwise, it looks like I have...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

  • RE: Backup Exec 12.5 for SQL Backups, nothing Else?

    I don't know if anyone else does this, but after every full backup, I immediately generate a transaction log backup. This may be due to paranoia that if a...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

  • RE: Catching errors in DBCC CHECKDB

    Wouldn't the backup fail because of a corrupt table?

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

  • RE: Backup Exec 12.5 for SQL Backups, nothing Else?

    CirquedeSQLeil (11/3/2009)


    Not a fan of direct to tape backup solutions. I like to have my backups to disk and then a tape backup copy the bak file to tape...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

  • RE: It's Time for Encryption

    Mad Hacker (11/3/2009)


    While reaing this article I was reminded of an old episode of 60 Minutes on CBS where they were interviewing a professional car thief. When the thief...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

  • RE: It's Time for Encryption

    For those worried about the loss of keys, do what we do in our company.

    Any new or changed encryption key is always in two parts. The security team typically...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

  • RE: Are the posted questions getting worse?

    I've been wondering if people who accidentally stumble onto the first page of the THREAD and casually go from page to page, not realizing how long it has grown? ...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

  • RE: File Groups

    SanjayAttray (10/19/2009)


    Very good question. I was asked this question in an interview.

    Q). What's the easiest and fastest way to move data of a table from file1 to file2?

    A). Move...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

  • RE: Newest SQL Patch?

    Much obliged. Now to figure out which ones to do this on, LOL. We're still patching to the previous hotfix.

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

Viewing 15 posts - 181 through 195 (of 459 total)