Forum Replies Created

Viewing 15 posts - 22,381 through 22,395 (of 49,552 total)

  • RE: ASYNC_NETWORK_IO wait type

    If the client app is the cause, yes.

    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

    November 9, 2011 at 9:53 am

    #1405352

  • RE: Backup - full recovery Model and log files

    codebyo (11/9/2011)

    If a transaction is rolled back, will the VLF used by that transaction be set to inactive even without performing a log backup? Or it must be kept active...

    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

    November 9, 2011 at 9:50 am

    #1405347

  • RE: Are the posted questions getting worse?

    SQLRNNR (11/9/2011)

    GilaMonster (11/9/2011)

    Roy Ernest (11/9/2011)

    Darn, I was submitting an article here and as soon as I uploaded an image, it removed all the previous text I entered. That was painful....

    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

    November 9, 2011 at 9:47 am

    #1405338

  • RE: Are the posted questions getting worse?

    Roy Ernest (11/9/2011)

    Darn, I was submitting an article here and as soon as I uploaded an image, it removed all the previous text I entered. That was painful. Anyone else...

    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

    November 9, 2011 at 9:34 am

    #1405319

  • RE: ASYNC_NETWORK_IO wait type

    Async network IO is usually a result of a client app that's slow to receive or process the resultset from SQL Server.

    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

    November 9, 2011 at 9:34 am

    #1405317

  • RE: How can I tell if my database has Implicit Transactions On?

    nicholasr 68909 (11/9/2011)

    I might be misunderstanding something but when setting ANSI_DEFAULTS to on I would be also setting implicit transactions on which from what I am reading here is 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

    November 9, 2011 at 9:28 am

    #1405311

  • RE: Backup - full recovery Model and log files

    Taggs (11/9/2011)

    Hmm, I'm a little confused. Although the file still has the data (which I thought it had cleared) that portion is now reusable?

    Yup. Nothing's actually cleared when a log...

    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

    November 9, 2011 at 9:21 am

    #1405305

  • RE: IsNull vs (@parameter is null or myfield = @parameter)

    HowardW (11/9/2011)

    Just for fun, for the original OR statement I get a seek on a range with this example in 2008:

    Yes, the original OR you will, because in that it's...

    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

    November 9, 2011 at 9:17 am

    #1405301

  • RE: IsNull vs (@parameter is null or myfield = @parameter)

    HowardW (11/9/2011)

    GSquared (11/9/2011)

    However, if the queries were written to get the same results as each other, IsNull will have the same performance as OR, since they do the same thing...

    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

    November 9, 2011 at 8:31 am

    #1405256

  • RE: Error 601 SQL Server 2008

    Ninja's_RGR'us (11/9/2011)

    -Syd- (11/9/2011)

    The report was working correct!! Just went wrong a few minutes ago!

    It's an intermittant error.

    You can be 100% certain it will happen again. It's just a matter...

    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

    November 9, 2011 at 8:30 am

    #1405254

  • RE: IsNull vs (@parameter is null or myfield = @parameter)

    In that case, this link does apply. http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-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

    November 9, 2011 at 8:23 am

    #1405244

  • RE: Backup - full recovery Model and log files

    Taggs (11/9/2011)

    My understanding is that when I take a SQL Full backup my log files are cleared out (NOT SHRUNK) and new trans log data is saved.

    No. Full backups don't...

    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

    November 9, 2011 at 8:22 am

    #1405240

  • RE: Error 601 SQL Server 2008

    -Syd- (11/9/2011)

    [font="Tahoma"]Hi all, im getting this error:

    "Msg 601, Level 12, State 3, Line 470

    Could not continue scan with NOLOCK due to data movement."

    Im using "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;"...

    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

    November 9, 2011 at 8:06 am

    #1405219

  • RE: IsNull vs (@parameter is null or myfield = @parameter)

    Edit: Sorry, I thought the param was the one with the IS NULL check

    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

    November 9, 2011 at 8:03 am

    #1405216

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (11/9/2011)

    Am I the only 1 who wants to answer... if you don't know that, then why are you teaching this stuff??

    http://www.sqlservercentral.com/Forums/Topic1202806-150-1.aspx

    Haven't you forgotten the old saying - 'Those who...

    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

    November 9, 2011 at 7:54 am

    #1405204

Viewing 15 posts - 22,381 through 22,395 (of 49,552 total)