Forum Replies Created

Viewing 15 posts - 41,476 through 41,490 (of 49,552 total)

  • RE: Correct use of @variables and uniqueidentifiers

    PG (1/22/2009)

    But how do you show the "one to many" relationship when an Expert has more than one Category to their credit? Or when a Category has more than one...

    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

    January 22, 2009 at 1:56 pm

    #931447

  • RE: Are deadlocks more frequent in 2005 due to page level locks?

    DBADave (1/22/2009)

    although who is to say the author is correct.

    Connor's currently the program manager of the Query Optimisation team and, previously (iirc) was one of the lead developers...

    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

    January 22, 2009 at 1:35 pm

    #931438

  • RE: How to prevent sysadmin from tracing using profiler...

    Network admins at my previous company didn't allow any of those to be used anywhere.

    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

    January 22, 2009 at 1:30 pm

    #931433

  • RE: Index Tuning

    You can always combine include columns without an effect

    You can usually combine the inequalities without breaking anything, not always

    You usually can't combine equality columns without causing a problem.

    I blogged earlier...

    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

    January 22, 2009 at 1:29 pm

    #931431

  • RE: Index Tuning

    tgarland (1/22/2009)

    I have thought about combining those into one index that looks like the following but I am not sure if that would make the index less valuable:

    Looks fine.

    This...

    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

    January 22, 2009 at 1:09 pm

    #931420

  • RE: How to prevent sysadmin from tracing using profiler...

    K. Brian Kelley (1/22/2009)

    Sorry, folks, but we have had solutions to prevent unencrypted data flowing across the data into SQL Server. 🙂

    We have em. The question of who uses 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

    January 22, 2009 at 12:55 pm

    #931410

  • RE: Are deadlocks more frequent in 2005 due to page level locks?

    DBADave (1/22/2009)

    32GB of memory.

    From those stats, SQL's using maybe 200MB of that for proc cache. Not much

    They have a lot of dynamic code executed from their application servers. 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

    January 22, 2009 at 12:53 pm

    #931409

  • RE: SHRINKING GOOD AFTER BIG TABLES ARE DROPPED?

    Hollyz (1/22/2009)

    In my organization, we dropped several tables that have lots of rows and saved about 5 GB of space by looking at the backup size. However, the database...

    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

    January 22, 2009 at 12:51 pm

    #931407

  • RE: Are deadlocks more frequent in 2005 due to page level locks?

    DBADave (1/22/2009)

    He said re-use(%) is low and asked to see our L2 cache. How does this pertain to L2 cache?

    It doesn't. That's looking at details of the procedure cache,...

    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

    January 22, 2009 at 12:42 pm

    #931396

  • RE: Are deadlocks more frequent in 2005 due to page level locks?

    Won't that only happen if multiple CPUs (multiple running worker threads) are after the exact same data at the exact same time?

    Dave: Talking about the processor cache impact on performance...

    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

    January 22, 2009 at 12:05 pm

    #931370

  • RE: Are deadlocks more frequent in 2005 due to page level locks?

    Roy Ernest (1/22/2009)

    Also whenever the worker attempts to access hot data structure protected by spinlock it potentially might have a less chance of acquiring the spinlock which will cause 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

    January 22, 2009 at 11:49 am

    #931354

  • RE: On Using JOINS in FROM clause

    Grant Fritchey (1/22/2009)

    I've been force-fed his chops before. The bruises heal.

    Whatever did you do to deserve that?

    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

    January 22, 2009 at 11:40 am

    #931345

  • RE: Are deadlocks more frequent in 2005 due to page level locks?

    DBADave (1/22/2009)

    His answer was that they have witnessed the Optimizer picking incorrect query plans that have lead to performance problems.

    Not uncommon, when one has out of date...

    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

    January 22, 2009 at 11:31 am

    #931336

  • RE: On Using JOINS in FROM clause

    Bob Hovious (1/22/2009)

    Never looked at the execution plan though.

    Providing you haven't left a cross join in by accident, it'll be the same as for the one with JOIN.

    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

    January 22, 2009 at 11:21 am

    #931331

  • RE: Dead lock occured

    Unfortunately, with sharepoint, there's not much you can do. You can't change the code and if you add any indexes, MS will no longer support you. From what I understand,...

    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

    January 22, 2009 at 10:29 am

    #931307

Viewing 15 posts - 41,476 through 41,490 (of 49,552 total)