Forum Replies Created

Viewing 15 posts - 13,126 through 13,140 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (5/17/2013)

    Lynn Pettis (5/17/2013)

    Lynn Pettis (5/17/2013)

    And we have another winner:

    After the date was changed to 2032 , scheduled jobs did run no issues. After changing the date to 2013...

    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 17, 2013 at 11:45 am

    #1616300

  • RE: Trigger worked in 2008, but not in 2008 R2

    And the trigger definition looks like....

    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 17, 2013 at 11:41 am

    #1616299

  • RE: WAITFOR DELAY causes a lock

    btw, the WAITFOR is not necessary to get that lock. USE ADVENTUREWORKS is sufficient.

    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 17, 2013 at 11:38 am

    #1616297

  • RE: Possible to repair or drop one damaged table

    Please post new questions in a new thread and give as much information as possible, including errors and the output of CheckDB.

    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 17, 2013 at 11:37 am

    #1616296

  • RE: WAITFOR DELAY causes a lock

    That's a shared database lock. Each and every running query, no matter what it's running, takes a shared database lock to ensure that the database can't be dropped while the...

    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 17, 2013 at 11:32 am

    #1616291

  • RE: How do you force the maxdop in the App plan to match the SSMS plan ?

    Grant Fritchey (5/17/2013)

    And look to the Cost Threshold for Parallelism. Compare that with the costs of the plans themselves. It could be that with different parameters compiled a different times,...

    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 17, 2013 at 11:29 am

    #1616289

  • RE: Are the posted questions getting worse?

    Lynn Pettis (5/17/2013)

    Is that from the same person who thinks that NOLOCK makes queries run faster?

    Which one of them?

    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 17, 2013 at 9:27 am

    #1616231

  • RE: CROSS JOIN vs INNER JOIN performance issue.

    T.Ashish (5/17/2013)

    So should I say that it is the old way of INNER JOINing tables, that will not be supported in future versions !!

    It's the old way, but it's not...

    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 17, 2013 at 9:24 am

    #1616230

  • RE: space issue

    Delete data, add more space or move stuff to another drive.

    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 17, 2013 at 9:09 am

    #1616224

  • RE: How do you force the maxdop in the App plan to match the SSMS plan ?

    As I said, MAXDOP is just the maximum number of processors and MAXDOP 0 means use up to the total number of processors, but it's up to the optimiser and...

    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 17, 2013 at 8:23 am

    #1616206

  • RE: CROSS JOIN vs INNER JOIN performance issue.

    T.Ashish (5/17/2013)

    If I use query 2/3, then optimizer must be converting it in Inner Join before execution. If I'm right then is there any way...

    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 17, 2013 at 8:22 am

    #1616203

  • RE: How do you force the maxdop in the App plan to match the SSMS plan ?

    Maxdop is just that, Maximum degree of parallelism, the maximum number of cores that the query can use. A query with MAXDOP 8 can run on a single core 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 17, 2013 at 7:57 am

    #1616190

  • RE: Are the posted questions getting worse?

    "I know the drawbacks of nolock, in our case it cannot be avoided"

    Hmm...

    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 17, 2013 at 7:24 am

    #1616172

  • RE: CROSS JOIN vs INNER JOIN performance issue.

    T.Ashish (5/17/2013)

    Though I know the drawbacks of NOLOCK, it can't be avoided in our case.

    Really? So you absolutely must allow potentially incorrect data in results because ....

    And regarding...

    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 17, 2013 at 7:22 am

    #1616171

  • RE: Have I been smoking something?? Insert construction question.

    marc.snoeys (5/17/2013)

    But, my personal opinion is that it would be more intuitive to be able to write an INSERT-statement just like an UPDATE-statement.

    Personally I'd prefer an update in the form...

    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 17, 2013 at 7:02 am

    #1616161

Viewing 15 posts - 13,126 through 13,140 (of 49,552 total)