Forum Replies Created

Viewing 15 posts - 1,816 through 1,830 (of 49,552 total)

  • RE: trouble wit a poor performing query

    Can you post execution plan (as a .sqlplan file) please?

    How does the performance change when you use a temp table instead of the table variable?

    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

    February 7, 2017 at 3:40 pm

    #1927218

  • RE: Good headphones for all day at work?

    I've got a pair of Bose QC15s (wired noise-cancelling). Fantastic headphones, but not cheap.

    I would recommend spending a little extra on headphones, if you use them every day,...

    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

    February 7, 2017 at 11:03 am

    #1927164

  • RE: Are the posted questions getting worse?

    9 year member of this site, 9 years of asking DBA questions, and can't write a differential backup script...

    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

    February 7, 2017 at 10:59 am

    #1927162

  • RE: Are the posted questions getting worse?

    BLOB EATER - Tuesday, February 7, 2017 4:28 AM

    For the presenters out there do you use the USB presentation clicker with the laser...

    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

    February 7, 2017 at 10:53 am

    #1927160

  • RE: High Memory Usage

    ThomasRushton - Tuesday, February 7, 2017 4:57 AM

    If you want to avoid memory pressures, and you want to avoid waiting 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

    February 7, 2017 at 10:52 am

    #1927158

  • RE: Your Favorite Feature that Needs Work

    I saw a feature from Stream Analytics today that I would love to have in T-SQL

    GROUP BY TransactionDate(Hour, 1)

    Essentially group by one hour intervals of 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

    February 7, 2017 at 10:49 am

    #1927155

  • RE: LCK_M_IX waittype is found in SQL SERVER

    It's a wait to acquire an Intent-Exclusive lock. Short duration waits are not a problem, and are expected. If you've got longer-duration waits, then you probably have some inefficient queries...

    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

    February 5, 2017 at 2:02 pm

    #1926771

  • RE: I can't query SQL Server over internet

    bmg002 - Friday, February 3, 2017 8:55 AM

    Also, this is probably another dumb question, but are you sure that is 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

    February 3, 2017 at 2:43 pm

    #1926707

  • RE: AlwaysOn and Failover Clustering for HA\DR

    Divine Flame - Thursday, February 2, 2017 11:55 AM

    1. How many SQL Server licences I would require for this type of HA\DR setup

    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

    February 3, 2017 at 8:27 am

    #1926622

  • RE: I can't query SQL Server over internet

    WebTechie - Thursday, February 2, 2017 10:51 AM

    Does anyone have a thought or an idea of why we can't query our server...

    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

    February 3, 2017 at 8:23 am

    #1926619

  • RE: DBCC CheckTable -- Help Please?

    Try dropping the index you identified and recreating it (not rebuild. Drop and then create as two separate operations), then run checktable again and see if the errors are gone.

    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

    February 3, 2017 at 8:18 am

    #1926618

  • RE: Upgrading to SQL 2016 - Any Gotcha's

    The linked servers will be fine. What will catch you is the cardinality estimator change that was made for SQL 2014. Most queries either stay the same or experience 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

    February 3, 2017 at 8:16 am

    #1926617

  • RE: High Memory Usage

    WhiteLotus - Thursday, February 2, 2017 8:38 PM

    In our production server , memory usage is around 95% even tho it has been...

    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

    February 3, 2017 at 8:14 am

    #1926615

  • RE: When to mess with CPU affinity?

    Van Heghe Eddy - Friday, February 3, 2017 4:21 AM

    Hi Kerri,

    Please note: 5 year old thread, and the person you're replying 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

    February 3, 2017 at 8:09 am

    #1926611

  • RE: Best way to determine to Clustered index keys

    Robin35 - Friday, February 3, 2017 7:20 AM

    Once we find the index, how do we deploy it in production with 1...

    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

    February 3, 2017 at 8:07 am

    #1926608

Viewing 15 posts - 1,816 through 1,830 (of 49,552 total)