Forum Replies Created

Viewing 15 posts - 25,051 through 25,065 (of 49,552 total)

  • RE: Same statements, different plans?

    Try updating statistics (with fullscan if necessary) and putting the parameters back in the queries.

    If parameter sniffing is causing a problem on a fresh compile it means there's something wrong...

    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

    July 7, 2011 at 4:45 pm

    #1350093

  • RE: Are the posted questions getting worse?

    Jim Murphy (7/7/2011)

    But next year, I'm probably going to want to fly them out too. Uh, to North Carolina apparently. Maybe this year, I can meet someone...

    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

    July 7, 2011 at 4:40 pm

    #1350089

  • RE: make sargable

    You can change this

    SELECT * FROM @table WHERE (calories <> '' AND calories IS NOT NULL)

    to this

    SELECT * FROM @table WHERE calories <> ''

    and it will still do what 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

    July 7, 2011 at 4:33 pm

    #1350087

  • RE: Same statements, different plans?

    Update statistics?

    The proc can do parameter sniffing, meaning it looks at the values of the parameters and checks those against the stats to get a row estimate.

    The statements can't sniff,...

    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

    July 7, 2011 at 4:29 pm

    #1350085

  • RE: Delete Query and 'Transaction Log is full' Error

    dso808 (7/7/2011)

    Hi Gail and thanks so much for your response. OK, the disk where our transaction log file is stored only has about 13GB of space available. Last...

    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

    July 7, 2011 at 3:57 pm

    #1350076

  • RE: Deadlock encountered

    The range locks were the hint. That means serialisable or some foreign key-related stuff.

    Serialisable's a nasty one. Extensive locks held for the duration of the transaction. Without care, it makes...

    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

    July 7, 2011 at 2:36 pm

    #1350043

  • RE: Difference between clustered and non clustered index..

    SQLkiwi (7/7/2011)

    GilaMonster (7/7/2011)

    I've worked with a lot of them. When all queries against a table filter on the date (inserted date, transaction date or similar), the date column 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

    July 7, 2011 at 2:29 pm

    #1350038

  • RE: Server Rent :: VoIPSwitch :: VOS3000 :: Mera MVTS :: Nextone :: Asterisk..With All Module + Dedicated server for Rent USD 140 with 24/7Support

    Spam. Reported. No replies please.

    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

    July 7, 2011 at 2:07 pm

    #1350023

  • RE: Server Rent :: VoIPSwitch :: VOS3000 :: Mera MVTS :: Nextone :: Asterisk..With All Module + Dedicated server for Rent USD 140 with 24/7Support

    Spam. Reported. No replies please.

    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

    July 7, 2011 at 2:06 pm

    #1350021

  • RE: Can non partitioned indexes prevent partition splitting/merging?

    iirc it's switching a partition in/out that a non-partition aligned index breaks, not splitting and merging.

    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

    July 7, 2011 at 2:05 pm

    #1350019

  • RE: Server Rent :: VoIPSwitch :: VOS3000 :: Mera MVTS :: Nextone :: Asterisk..With All Module + Dedicated server for Rent USD 140 with 24/7Support

    Spam. Reported. No replies please.

    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

    July 7, 2011 at 2:04 pm

    #1350017

  • RE: Difference between clustered and non clustered index..

    Jayanth_Kurup (7/7/2011)

    Don't really have many date based queries.

    I've worked with a lot of them. When all queries against a table filter on the date (inserted date, transaction...

    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

    July 7, 2011 at 1:49 pm

    #1349998

  • RE: partion of RAM between SQL server and Cluster server

    So does it have 75 or 103?

    Am not following 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

    July 7, 2011 at 12:45 pm

    #1349944

  • RE: partion of RAM between SQL server and Cluster server

    How much memory does the server have total?

    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

    July 7, 2011 at 12:36 pm

    #1349936

  • RE: sp VS adhoc query peformance?

    Please note: 3 year old thread.

    Why would you recommend setting every single statistic in the database to not get automatically updated again? Very dangerous setting without some manual stats updates...

    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

    July 7, 2011 at 12:33 pm

    #1349933

Viewing 15 posts - 25,051 through 25,065 (of 49,552 total)