Forum Replies Created

Viewing 15 posts - 4,351 through 4,365 (of 8,415 total)

  • RE: Speed up a database shrink

    CirquedeSQLeil (4/2/2010)


    You could do it that way, or you could setup the replication with the snapshot and filters to get what you need. You would recreate it each time...

  • RE: Don't forget this date.

    CirquedeSQLeil (4/2/2010)


    Surprised it hasn't happened yet.

    vk-kirov covered it!

  • RE: Are the posted questions getting worse?

    Lynn Pettis (4/2/2010)


    I used to be the same. Commuted to Denver from Colorado Springs for 15 years, survived on 4 hours sleep Monday through Friday.

    Had to Google that to...

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (4/2/2010)


    Sounds like a gauntlet throw down there.

    Just an observation 🙂

  • RE: The transient database snapshot for database 'DB1' (database ID 5) has been marked suspect due to an IO operation failure.

    Interesting that the limit on sparse file size reduced from 64GB (Windows 2003) to 16GB (Windows 2008, Vista). There appears to be a QFE for this: http://support.microsoft.com/default.aspx/kb/957065

  • RE: Are the posted questions getting worse?

    Lynn Pettis (4/2/2010)


    You know, if Paul keeps up this pace (100 pts/day average) in 2 months he'll be breathing down Barry's neck. Another 30 days, he'll quite possibly be...

  • RE: Are the posted questions getting worse?

    GilaMonster (4/2/2010)


    Paul White NZ (4/2/2010)


    GilaMonster (4/2/2010)


    'Table variables are not affected by explicit transaction rollbacks'?

    Operations performed on a table variable within a transaction are not undone if that transaction aborts.

    Except that...

  • RE: SSMS 2008 Stored Proc WITH RECOMPILE

    "Atypical parameters" refers to the fact that SQL Server may cache a plan based on the actual parameter values passed on the first call of a procedure. If those...

  • RE: Are the posted questions getting worse?

    GilaMonster (4/2/2010)


    'Table variables are not affected by explicit transaction rollbacks'?

    Operations performed on a table variable within a transaction are not undone if that transaction aborts.

  • RE: Are the posted questions getting worse?

    How about:

    "Table variables are weird...not quite a variable...not quite a table. Go figure."

    😀

  • RE: Creating Indices on Temp Tables from Stored Procedures

    I can appreciate your point of view. Thanks for sharing.

  • Viewing 15 posts - 4,351 through 4,365 (of 8,415 total)