Forum Replies Created

Viewing 15 posts - 646 through 660 (of 49,552 total)

  • RE: Operating system error 5: "5(Access is denied.)".

    Eirikur Eiriksson - Wednesday, November 15, 2017 1:10 AM

    Quick thought, either the right permissions aren't in place or this might even be...

    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

    November 15, 2017 at 1:20 am

    #1968123

  • RE: S?QL Server using 97% of RAM.

    Grant Fritchey - Tuesday, November 14, 2017 1:51 PM

    Jeff Moden - Tuesday, November 14, 2017 8:56 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

    November 15, 2017 at 1:15 am

    #1968122

  • RE: MS SQL Server - Frequent Deadlock Issues

    To start with, the deadlocks are on row-level locks, not table level, so lock escalation will have no effect here. Please turn it back on.

    The key, I suspect,...

    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

    November 15, 2017 at 1:12 am

    #1968121

  • RE: Operating system error 5: "5(Access is denied.)".

    The account that SQL Server is running under does not have access to your users folder. Hence the OS permission denied error

    Best thing to do is to create...

    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

    November 15, 2017 at 1:03 am

    #1968118

  • RE: Trigger table read?

    No. Insert, update and delete only.

    What are you trying to do?

    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

    November 12, 2017 at 1:50 am

    #1967657

  • RE: Odd behavior with views

    I'd ask for a reproducable example with proper timing tests done enough times that you can tell whether the difference is statistically significant.

    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

    November 11, 2017 at 10:55 am

    #1967643

  • RE: TransactionLog. VLF Fragmentation.

    dmbsseller - Friday, November 10, 2017 11:06 PM

    3) disabled maintenace plan of rebuild/reorganize indexes and update statistics and monitoring situation. (Actually...

    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

    November 11, 2017 at 10:54 am

    #1967642

  • RE: Fill Factor

    Arsh - Saturday, November 11, 2017 5:23 AM

    For more clarity on this point , when a new row is inserted ,...

    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

    November 11, 2017 at 10:52 am

    #1967641

  • RE: Database Corruption

    d_gomes2 - Wednesday, November 8, 2017 3:36 AM

    Hi Gail,
    How Can I look or test the Subsystem IO in order to performance same checks.
    Thank...

    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

    November 8, 2017 at 3:45 am

    #1967118

  • RE: t-SQL Solution to backup and restore

    river1 - Wednesday, November 8, 2017 2:57 AM

    But why two tables? can't I find all the infromation in just one table?

    Because 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

    November 8, 2017 at 3:29 am

    #1967113

  • RE: Database Corruption

    Drives are a small part of a modern IO subsystem. The error can be anywhere in the stack.

    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

    November 8, 2017 at 3:20 am

    #1967110

  • RE: Database Corruption

    99% of corruption is caused by a faulty IO subsystem. Could be anything from filter drivers right down to the disk. There's a lot of moving parts in a modern...

    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

    November 8, 2017 at 3:12 am

    #1967104

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

    tony28 - Wednesday, November 8, 2017 2:57 AM

    ok , but do you think that will do only on one index 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

    November 8, 2017 at 3:10 am

    #1967103

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

    tony28 - Wednesday, November 8, 2017 1:29 AM

    GilaMonster - Thursday, October 26, 2017 9:47 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

    November 8, 2017 at 2:07 am

    #1967095

  • RE: Changing NVARCHAR to VARCHAR...

    Arsh - Wednesday, November 8, 2017 12:46 AM

    Hi Jeff. I've been working on SQL server for 7 years now and 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

    November 8, 2017 at 12:53 am

    #1967086

Viewing 15 posts - 646 through 660 (of 49,552 total)