Forum Replies Created

Viewing 15 posts - 26,341 through 26,355 (of 49,552 total)

  • RE: Transaction

    Sure, that setting will let you read through the locks. It also means uncommitted and potentially rolled back changes, potential for duplicate reads or missing rows entirely.

    It is NOT a...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 3, 2011 at 1:47 pm

    #1319365

  • RE: Is this a good backup strategy?

    Just to pile on, an untested backup strategy is not a backup strategy. It's a backup desperate hope.

    I've seen someone cause 4 hours additional downtime during a disaster because he...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 3, 2011 at 12:14 pm

    #1319302

  • RE: Open Transactions Stuck in the Log of SIMPLE RECOVERY MODE Database

    MostInterestingMan (5/3/2011)

    GilaMonster (5/3/2011)

    It could be that the log reader is falling behind. Start checking the replication agents' logs.

    I think it has. I will check the logs.

    Could be anything from huge...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 3, 2011 at 12:00 pm

    #1319286

  • RE: Log Truncation Opinions requested

    mike 57299 (5/3/2011)

    If you truncate the t-log you will not be able to use a previous full backup to start a recovery if a more current full backup file turns...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 3, 2011 at 11:33 am

    #1319261

  • RE: Open Transactions Stuck in the Log of SIMPLE RECOVERY MODE Database

    Syed Jahanzaib Bin hassan (5/3/2011)

    you can use this command on SQL Server 2008 and 2008 R2 also,if you want to truncate the file just add new log file and restrict...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 3, 2011 at 11:31 am

    #1319259

  • RE: Issue in moving db files to different folder - urgent

    Take the database offline

    Either move the file or run alter database again (note alter database will NOT move the file for you. You have to do that)

    Bring the database online.

    A...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 3, 2011 at 9:52 am

    #1319186

  • RE: Open Transactions Stuck in the Log of SIMPLE RECOVERY MODE Database

    It could be that the log reader is falling behind. Start checking the replication agents' logs.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 3, 2011 at 9:40 am

    #1319178

  • RE: Try Catch Failed??

    Deferred name resolution. At parse of the batch the object didn't exist, so the statement was not bound or optimised. Just before the statement ran, SQL tried again to parse,...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 3, 2011 at 9:30 am

    #1319171

  • RE: Try Catch Failed??

    Syntax errors (including missing objects) won't trigger a try/catch.

    From Books Online:

    The following types of errors are not handled by a CATCH block when they occur at the same level of...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 3, 2011 at 9:27 am

    #1319164

  • RE: TempDB is Unneccessary

    Ninja's_RGR'us (5/3/2011)

    Ya, I've never had a video that was so big that I couldn't stream it.

    I hate you. Just saying... 😉

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 3, 2011 at 9:16 am

    #1319160

  • RE: TempDB is Unneccessary

    Ninja's_RGR'us (5/3/2011)

    GilaMonster (5/3/2011)

    Ninja's_RGR'us (5/3/2011)

    Steve Jones - SSC Editor (5/3/2011)

    There are a few things that will automatically go to disk with tempdb. After some checking, you cannot get away from spillage...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 3, 2011 at 9:10 am

    #1319152

  • RE: TempDB is Unneccessary

    Ninja's_RGR'us (5/3/2011)

    Steve Jones - SSC Editor (5/3/2011)

    There are a few things that will automatically go to disk with tempdb. After some checking, you cannot get away from spillage during queries....

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 3, 2011 at 8:57 am

    #1319140

  • RE: Is this a good backup strategy?

    Raymond van Laake (5/3/2011)

    Agreed, but does SQL recognize that the first half hour from the 9:30 transaction log, is already back in place because the 10:00 differential backup was restored...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 3, 2011 at 8:03 am

    #1319096

  • RE: Alternative to DBCC INPUTBUFFER/sys.dm_exec_sql_text? (new sp_who proc)

    Ninja's_RGR'us (5/3/2011)

    GilaMonster (5/3/2011)

    <grrrr> 3 year old thread.

    Why does it bother you? People read this from google today so it's still usefull!

    Because I didn't notice and wrote a couple paragraphs...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 3, 2011 at 7:40 am

    #1319077

  • RE: Why @@MAX_CONNECTIONS is Nondeterministic Functions

    parthi-1705 (5/3/2011)

    If so then we can change the default language also which is @@LANGUAGE ,if we run this it will return as us_english or what ever it has been configured,if...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 3, 2011 at 7:36 am

    #1319073

Viewing 15 posts - 26,341 through 26,355 (of 49,552 total)