Forum Replies Created

Viewing 15 posts - 691 through 705 (of 49,552 total)

  • RE: Extended Events - sqlserver.query_memory_grant_usage

    There's nothing wrong here.

    That event was added in SQL Server 2016.
    It won't be present on a 2014 server. Nothing to do with the service pack,...

    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

    October 29, 2017 at 9:20 am

    #1965696

  • RE: Extended Events - sqlserver.query_memory_grant_usage

    That event was added in SQL Server 2016
    https://www.sqlskills.com/blogs/bobb/over-1000-xevents-in-sql-server-2016-ctp2-here-are-the-new-ones/

    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

    October 29, 2017 at 9:09 am

    #1965694

  • RE: Extra Statistics

    You can get rid of them by dropping them (DROP STATISTICS). The Query Optimiser will recreate them as soon as it needs them, so unless the pattern of work has...

    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

    October 28, 2017 at 11:14 pm

    #1965688

  • RE: sql SELECT Count(*) works on single words only

    Thom A - Saturday, October 28, 2017 5:33 AM

    Where are you running your SQL statement from; what you've supplied is not value...

    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

    October 28, 2017 at 9:52 am

    #1965674

  • RE: Recover corrupted database

    farax_x - Tuesday, October 17, 2017 4:48 AM

    How can I recover this database?

    Restore from backup.  You cannot mix and match data files.
    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

    October 28, 2017 at 9:51 am

    #1965673

  • RE: KEY Lookup vs RID Lookup

    Gamleur84 - Friday, October 27, 2017 10:27 AM

    Then I thought, well at least SQL could potentially do a Clustered Index Scan or...

    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

    October 27, 2017 at 3:24 pm

    #1965631

  • RE: Question - DB Certificate expiration (Column level encryption)

    SQL!$@w$0ME - Friday, October 27, 2017 6:46 AM

    Thanks Gail! Does that mean I don't have to worry about cert expiration?

    Um...

    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

    October 27, 2017 at 10:12 am

    #1965552

  • RE: KEY Lookup vs RID Lookup

    Gamleur84 - Friday, October 27, 2017 9:56 AM

     How about tweaking the query/index in order to get a Clustered Index Seek ?

    Remove columns...

    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

    October 27, 2017 at 10:10 am

    #1965549

  • RE: StartDate and EndDate in same column

    Redmond01 - Thursday, October 26, 2017 6:15 PM

    Well basically my Rundate column is in ascending order and I have to  setstart 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

    October 26, 2017 at 10:36 pm

    #1965452

  • RE: App timing out, but sproc runs in 3 seconds

    butcherking13 - Thursday, October 26, 2017 9:01 PM

    Why would a simple query/sproc that takes 3 seconds to run in SSMS blow 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

    October 26, 2017 at 10:33 pm

    #1965451

  • RE: KEY Lookup vs RID Lookup

    Key lookup and RID lookup are the same thing, they're single-row reads of either the clustered index (key) or heap (RID)

    They certainly would be blocked by X locks,...

    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

    October 26, 2017 at 5:21 pm

    #1965423

  • RE: Question - DB Certificate expiration (Column level encryption)

    https://docs.microsoft.com/en-us/sql/t-sql/statements/create-certificate-transact-sql

    EXPIRY_DATE =' datetime'
    Is the date on which the certificate expires. If not specified, EXPIRY_DATE is set to a date one year after START_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

    October 26, 2017 at 4:01 pm

    #1965416

  • RE: Data row does not have a matching index row in the index

    You have a hardware problem. Corruption is mostly a hardware problem. It's got nothing whatsoever to do with the size of the index.

    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

    October 26, 2017 at 9:47 am

    #1965350

  • RE: Are the posted questions getting worse?

    Sean Lange - Thursday, October 19, 2017 3:30 PM

    Oh how I love third party databases. I have been working with 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

    October 19, 2017 at 3:54 pm

    #1964435

  • RE: Windows Server 2012

    yrstruly - Thursday, October 19, 2017 12:17 AM

    Thank You for the advice 

    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

    October 19, 2017 at 9:39 am

    #1964367

Viewing 15 posts - 691 through 705 (of 49,552 total)