Forum Replies Created

Viewing 15 posts - 41,446 through 41,460 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Jeff Moden (1/24/2009)

    A perfect example can be found at the following link..

    http://www.sqlservercentral.com/Forums/Topic642789-338-1.aspx#bm642945

    🙂 I'm busy witting a correction to one of his posts now. "Correlated subquery, inner query is executed...

    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 25, 2009 at 1:57 am

    #932339

  • RE: how to find out the most frequently run queries in a database

    Marios Philippopoulos (1/24/2009)

    Hopefully, DMVs will be able to capture the remaining info in future versions of SQL Server...

    I doubt they'll ever replace SQL trace because the DMVs, like extended events,...

    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 24, 2009 at 9:12 am

    #932225

  • RE: Why do people need to do this?

    Jeff Moden (1/24/2009)

    To make a longer story shorter, I normally try to write gender agnostic replies when I don't know someone and, one day in a response to "ggraber", I...

    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 24, 2009 at 9:10 am

    #932224

  • RE: Newbie:Why is select doing a table scan?

    Ed (1/23/2009)

    Are either of these useful?

    No. The image doesn't contain all the info, there's a lot that's in tooltips and operator properties. The xml (if that's what you saved to...

    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 24, 2009 at 1:35 am

    #932191

  • RE: Scheduled Transaction Log Backups

    Ellen (1/23/2009)

    The transaction log backup file is appended to with each log backup, it has grown from around 5 Gb to 8 Gb from Wednesday till today.

    That may be 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 24, 2009 at 1:21 am

    #932190

  • RE: SQL Server Architecture? What's going on behind the scenes?

    ashepard (1/23/2009)

    So does that mean the disk should be formatted for 8k sector size?

    No.

    There's lots of info on IO config for SQL. Google should find them for...

    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 24, 2009 at 1:20 am

    #932188

  • RE: high cnter

    Is there any blocking?

    Has the volumes of data changed?

    Are your indexes defragmented and your stats up to 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 24, 2009 at 1:18 am

    #932187

  • RE: Newbie:Why is select doing a table scan?

    Ed (1/23/2009)

    Thanks for your help. I'm using Toad for SQL Server, so hopefully this is the format you're looking for.

    No. I was looking for the exec plan that management...

    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 23, 2009 at 2:38 pm

    #932071

  • RE: Table Join on Hash Match vs Nested Loop

    kwiggans (1/23/2009)

    My question is why is there such a great performance difference between the two methods, and should I avoid using concatenated columns in my table JOIN statements in 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 23, 2009 at 2:27 pm

    #932063

  • RE: how to find out the most frequently run queries in a database

    Marios Philippopoulos (1/23/2009)

    There is a risk that the data from the DMV dm_exec_query_stats is regularly flushed from memory if there is memory pressure in your system.

    There's a couple other...

    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 23, 2009 at 2:23 pm

    #932057

  • RE: how to find out the most frequently run queries in a database

    KATHLEEN Y ZHANG (1/23/2009)

    I hope running trace as a background job is much less intrusive.

    It is. Grant explained why - http://scarydba.wordpress.com/2008/12/18/profiler-research/

    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 23, 2009 at 2:14 pm

    #932050

  • RE: Scheduled Transaction Log Backups

    Ellen (1/23/2009)

    I don't know why the original DBA created the log with 4 files. They are/were on the same physical drive so there was nothing gained. I have...

    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 23, 2009 at 2:07 pm

    #932047

  • RE: Newbie:Why is select doing a table scan?

    Ed (1/23/2009)

    So even if 20 coded columns need to access the lookup table to decode to descriptions, a table scan will be performed 20 times?

    Not sure what you're...

    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 23, 2009 at 2:06 pm

    #932046

  • RE: high cnter

    Why do you think you have a performance issue?

    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 23, 2009 at 1:34 pm

    #932022

  • RE: Scheduled Transaction Log Backups

    Few questions.

    Why is the tran log set up as 4 files?

    Are the log files on a separate physical drive from the data files?

    Likewise, is the drive that the log backups...

    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 23, 2009 at 1:28 pm

    #932015

Viewing 15 posts - 41,446 through 41,460 (of 49,552 total)