Forum Replies Created

Viewing 15 posts - 721 through 735 (of 49,552 total)

  • RE: Large SQL server under utilizing memory

    aman4God - Friday, September 29, 2017 9:36 AM

     When I see the server under load and the system reports that SQL has over...

    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

    September 29, 2017 at 2:47 pm

    #1961742

  • RE: Best Practice to Write a View for 3rd Parties

    kevaburg - Friday, September 29, 2017 8:24 AM

     and seeing as locks aren't imposed or escalated during a SELECT.

    Err.... What?

    Nolock is bad practice...

    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

    September 29, 2017 at 8:36 am

    #1961662

  • RE: Alter Table....Add Column

    A row cannot be stored across multiple pages (LOB data types notwithstanding). When you add a column, the data has to be added to each row.

    Given that, what...

    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

    September 29, 2017 at 6:37 am

    #1961609

  • RE: SQL 2016 Standard Edition maxmemory utilization

    Express12 - Friday, September 29, 2017 6:13 AM

    Does this mean the 768 GB RAM over-allocation of 640 GB (for BP) and 704...

    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

    September 29, 2017 at 6:27 am

    #1961603

  • RE: Are the posted questions getting worse?

    WayneS - Thursday, September 28, 2017 2:00 PM

    Steve Jones - SSC Editor - Thursday, September 28, 2017...

    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

    September 28, 2017 at 11:33 pm

    #1961517

  • RE: Large SQL server under utilizing memory

    How are you checking memory? Where do you see that SQL's only using 2.4GB of memory?

    What's your max server memory setting?

    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

    September 28, 2017 at 11:18 pm

    #1961514

  • RE: diff backup during full backup

    tony28 - Thursday, September 28, 2017 10:26 PM

    So also with two jobs is possible that diff will wait for full backup ?

    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

    September 28, 2017 at 11:16 pm

    #1961513

  • RE: Hash index on memory-optimized table

    I'm not sure either, there are some funnies with in-memory and execution plans.
    Let me consult an expert.

    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

    September 28, 2017 at 3:31 pm

    #1961486

  • RE: Dynamically create table with full structure

    89netanel - Thursday, September 28, 2017 6:00 AM

    I don'r have many experience with partitioning.
    and also the instance Edition is Standard 🙁

    Partitioning is...

    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

    September 28, 2017 at 12:05 pm

    #1961432

  • RE: Adding second data file to quickly growing msdb

    Eliyahu - Thursday, September 28, 2017 7:10 AM

    Moving the file didn't work. The SQL Server didn't recognize the file in the new...

    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

    September 28, 2017 at 7:35 am

    #1961346

  • RE: Dynamically create table with full structure

    Have you considered table partitioning?

    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

    September 28, 2017 at 5:53 am

    #1961307

  • RE: Hash index on memory-optimized table

    Have you looked at the execution plan?

    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

    September 28, 2017 at 1:41 am

    #1961281

  • RE: diff backup during full backup

    The differential backup will be blocked by the full, and hence will only execute after the full backup has completed, and hence it'll be obvious which diff you'd use 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

    September 27, 2017 at 2:21 am

    #1961104

  • RE: SQL Server Audit - How to track sysadmin activity involving SQL Agent and SQL Agent jobs?

    DML triggers on the relevant tables in msdb would be my first guess. Jobs are stored as data in MSDB.

    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

    September 26, 2017 at 4:38 pm

    #1961073

  • RE: Are the posted questions getting worse?

    Jeff Moden - Tuesday, September 26, 2017 2:53 PM

    It turns out that most of the queries that we previously identified as...

    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

    September 26, 2017 at 3:09 pm

    #1961062

Viewing 15 posts - 721 through 735 (of 49,552 total)