Forum Replies Created

Viewing 15 posts - 1,276 through 1,290 (of 49,552 total)

  • RE: Application Slow on Test Instance

    ThomasRushton - Wednesday, June 14, 2017 4:23 AM

    Hang on.  You've got your test environment on the same hardware as your production environment?

    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

    June 14, 2017 at 4:24 am

    #1946701

  • RE: Application Slow on Test Instance

    What's your question?

    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

    June 14, 2017 at 4:16 am

    #1946699

  • RE: Where to put the Group By clause?

    You don't need a group by on that query, as it has no aggregation.
    Group By in SQL is used to do aggregations (sum, avg, count, min, max, etc) per...

    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

    June 13, 2017 at 10:49 pm

    #1946677

  • RE: Query clustered index uniquifier

    Short of DBCC Page, no.
    Why are you interested?

    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

    June 13, 2017 at 3:12 pm

    #1946665

  • RE: NONCLUSTERED HASH index on memory optimized table

    No, it's a hash index. The indexes you have for in-memory tables are either hash indexes or range.
    Specifying HASH or NONCLUSTERED HASH gets you a hash index, specifying...

    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

    June 13, 2017 at 9:08 am

    #1946569

  • RE: SPID of top CPU consuming queries

    coolchaitu - Tuesday, June 13, 2017 7:16 AM

    John Mitchell-245523 - Tuesday, June 13, 2017 7:08 AM

    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

    June 13, 2017 at 7:31 am

    #1946545

  • RE: Are the posted questions getting worse?

    Brandie Tarvin - Tuesday, June 13, 2017 5:01 AM

    As part of my Grace Hopper SOL session, I'm committed to naming the different types...

    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

    June 13, 2017 at 6:41 am

    #1946536

  • RE: Best practice for simple concurrency challenge

    rice.tx - Monday, June 12, 2017 5:08 PM

    Jason A. Long - Monday, June 12, 2017 4:30 PM

    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

    June 13, 2017 at 4:02 am

    #1946494

  • RE: Data Integrity Check job failure

    There wouldn't be, they do exactly the same thing.

    Double-check what databases the checks were run on.

    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

    June 12, 2017 at 1:36 am

    #1946359

  • RE: Benefit of updating statistics after creating new index

    No, the stats are going to be up to date because you just created 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

    June 11, 2017 at 5:09 am

    #1946330

  • RE: Stored Procedure Performance After Creation

    jonathanmarenus - Saturday, June 10, 2017 4:45 PM

    I understand that stored procedures are compiled on the first run, possibly making the runtime...

    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

    June 11, 2017 at 5:07 am

    #1946329

  • RE: Database in recovery pending state

    nadersam - Sunday, June 11, 2017 12:32 AM

    Thank you i already restored the last differential backup but wanted to know the reason...

    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

    June 11, 2017 at 5:04 am

    #1946328

  • RE: Page Split

    Reduce the fill factor slightly. Test and repeat until acceptable.

    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

    June 11, 2017 at 5:03 am

    #1946327

  • RE: Clustered indexing and Non-clustered indexing

    http://www.sqlservercentral.com/stairway/72399/
    http://www.sqlinthewild.co.za/index.php/category/sql-server/indexes/

    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

    June 10, 2017 at 12:12 pm

    #1946305

  • RE: Clear all caches for index performance testing, every time?

    Indianrock - Saturday, June 10, 2017 8:24 AM

    Now that I'm testing without clearing any caches, I'm finding definite improvements to indexing don't...

    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

    June 10, 2017 at 11:15 am

    #1946304

Viewing 15 posts - 1,276 through 1,290 (of 49,552 total)