Forum Replies Created

Viewing 15 posts - 18,526 through 18,540 (of 49,552 total)

  • RE: Performance effect: Calling SP in the same DB VS Calling SP from other DB

    No.

    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 14, 2012 at 2:45 pm

    #1487393

  • RE: How Do You Verify Sequential Record Numbers.

    The problem there is if that's an identity column, there can be gaps even with the data complete. If any insert is ever rolled back and there's an identity column,...

    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 14, 2012 at 12:49 pm

    #1487331

  • RE: An examination of bulk-logged recovery model

    deepak_19888 (5/13/2012)

    When we switch the database recovery mode, from Full recivery to bulk- logged or vice versa, does some changes happen to the existing log file of the database too???...

    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 14, 2012 at 12:30 pm

    #1487321

  • RE: An examination of bulk-logged recovery model

    stevro (5/13/2012)

    I fail to fully understand why minimally logged operations can be slower . With the eager write process, should it not ease the burden on the transaction log by...

    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 14, 2012 at 11:00 am

    #1487264

  • RE: Managing Transaction Logs

    Take a read through this: http://www.sqlservercentral.com/articles/Recovery+models/89664/

    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 14, 2012 at 10:57 am

    #1487263

  • RE: Can we replace "inner hash join" with "inner join" in my quey, where to use "inner hash join" ?

    Yes you can and you should. The only time you should be using join hints is when you know exactly why the optimiser isn't choosing the join you want, you...

    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 14, 2012 at 10:54 am

    #1487261

  • RE: how to test the performance of 2 queries

    Row counts is one thing that causes estimation errors, but it's not the only thing. UDFs are another. There are more.

    Lots of things other than stats. See if you can...

    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 12, 2012 at 3:39 am

    #1486729

  • RE: how to test the performance of 2 queries

    Doesn't make the slightest difference if you use estimated or actual plan for the relative %. They'll be the same across the two plans and they are still estimates 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 12, 2012 at 3:00 am

    #1486724

  • RE: How Do You Verify Sequential Record Numbers.

    There are lots of ways to solve this, most incredibly slow.

    Google "Gaps and Islands" Itzik Ben Gan

    He's done an article recently comparing several methods of identifying gaps in a sequence.

    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 12, 2012 at 2:31 am

    #1486721

  • RE: how to test the performance of 2 queries

    Matthew Darwin (5/12/2012)

    You can try using the estimated query plan with both queries in te same batch, that will show a percentage of the batch that each query takes in...

    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 12, 2012 at 2:29 am

    #1486720

  • RE: Are the posted questions getting worse?

    Talking about London, heading that way tonight and won't have much time for SSC while I'm there. Could some people keep a watch for corrupt databases, production restores or anything...

    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 12, 2012 at 2:17 am

    #1486716

  • RE: Are the posted questions getting worse?

    Evil Kraig F (5/11/2012)

    GilaMonster (5/11/2012)

    WayneS (5/11/2012)

    GilaMonster (5/11/2012)

    Aaah, nerves. The wait is killing me...

    Must be... London?

    No.

    First Date then! Good luck!

    ??!!?? err....?????

    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 12, 2012 at 2:10 am

    #1486713

  • RE: caching a view

    No caching mechanisms. You could consider an indexed view, but that's something that you need to carefully analyse to see if it will fit, and there are lots of restrictions.

    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 12, 2012 at 2:06 am

    #1486711

  • RE: I NEED MS SQL SERVER 2008 LICENSE URGENTLY

    Contact your microsoft rep. Licences aren't resellable.

    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 12, 2012 at 2:04 am

    #1486710

  • RE: Where clause with view returns super slow!!!

    princa (5/11/2012)

    #1 - the where clause would be applied after result set generated from all tables or view join?

    No. The optimiser will try to push the filters as far...

    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 12, 2012 at 2:03 am

    #1486709

Viewing 15 posts - 18,526 through 18,540 (of 49,552 total)