Forum Replies Created

Viewing 15 posts - 3,766 through 3,780 (of 19,564 total)

  • RE: What if I have to shrink the database...:(

    Jeff Moden (2/10/2014)


    SQLRNNR (2/10/2014)


    Jeff Moden (2/10/2014)


    SQLRNNR (2/10/2014)


    jewel.sacred (2/10/2014)


    @Keith Tate Thanks a lot for quick the reply. I already had this in my mind but I am more comfortable with Michelle...

  • RE: Self blocking session could not be killed

    Now you just wait it out. The spid is in a rollback state and all you can do is wait for it to finish.

  • RE: What if I have to shrink the database...:(

    Jeff Moden (2/10/2014)


    SQLRNNR (2/10/2014)


    jewel.sacred (2/10/2014)


    @Keith Tate Thanks a lot for quick the reply. I already had this in my mind but I am more comfortable with Michelle Ufford's gem (No...

  • RE: Are the posted questions getting worse?

    Lynn Pettis (2/10/2014)


    Ed Wagner (2/7/2014)


    Lynn Pettis (2/7/2014)


    jasona.work (2/7/2014)


    Lynn Pettis (2/7/2014)


    I have been home since Sunday afternoon and today is the first day it has been warmer than it has been...

  • RE: What if I have to shrink the database...:(

    Jeff Moden (2/10/2014)


    Take a backup before doing the shrink and a backup prior to doing what comes up next...

    If you don't mind NOT having point-in-time backups while the indexes are...

  • RE: entry level job question

    Have you checked with the local recruiting agencies?

  • RE: Master Database in single user mode in 2008 R2 - but really not

    I have seen this happen at a client for the following reasons.

    Master database files were deleted (by the hosting service). The backup was restored on a different server and...

  • RE: What if I have to shrink the database...:(

    MyDoggieJessie (2/10/2014)


    @SQLRNNR - I agree with you 100% - I didn't say it wouldn't - I was saying it would not force new execution plans to be created.

    I was answering...

  • RE: What if I have to shrink the database...:(

    MyDoggieJessie (2/10/2014)


    Shrinking a database wouldn't cause the creation of any new execution plans.

    Yes, this will cause your log file(s) to fill/grow (especially so with the index maintenance)

    If space...

  • RE: What if I have to shrink the database...:(

    jewel.sacred (2/10/2014)


    @Keith Tate Thanks a lot for quick the reply. I already had this in my mind but I am more comfortable with Michelle Ufford's gem (No disrespect to Olla's...

  • RE: Today's Random Word!

    Ed Wagner (2/10/2014)


    SQLRNNR (2/10/2014)


    Stuart Davies (2/10/2014)


    Ed Wagner (2/10/2014)


    crookj (2/10/2014)


    Stuart Davies (2/10/2014)


    BWFC (2/10/2014)


    SQLRNNR (2/7/2014)


    L' Eomot Inversé (2/7/2014)


    SQLRNNR (2/7/2014)


    Confidence

    Trickster

    TURN

    Rotate

    Twist

    Ferris

    Bueller (anyone...anyone)

    Day off

    Eye disease

    Pink

    http://www.pinkspage.com/us/home

  • RE: Top Talent Leaves

    MHilsher (2/10/2014)


    Well I will add my 2 cents after over 30 years in the IT business. Including twice owning my own consulting business. And my pet peeve is...

  • RE: Top Talent Leaves

    hisakimatama (2/10/2014)


    Hm. Personally, I left my last job after a year and a half; things started out rather good, but after the first year, management became rather frustrating to...

  • RE: Today's Random Word!

    Stuart Davies (2/10/2014)


    Ed Wagner (2/10/2014)


    crookj (2/10/2014)


    Stuart Davies (2/10/2014)


    BWFC (2/10/2014)


    SQLRNNR (2/7/2014)


    L' Eomot Inversé (2/7/2014)


    SQLRNNR (2/7/2014)


    Confidence

    Trickster

    TURN

    Rotate

    Twist

    Ferris

    Bueller (anyone...anyone)

    Day off

    Eye disease

  • RE: Need Help

    Luis Cazares (2/10/2014)


    Welcome to the forums and SQL.

    Files with extension .sql are simple text files with scripts. You can't query them as a database.

    If you want help over skype or...

Viewing 15 posts - 3,766 through 3,780 (of 19,564 total)