Forum Replies Created

Viewing 15 posts - 1,411 through 1,425 (of 49,552 total)

  • RE: Msg 8181 - Text for 'MyProcedureName' is missing from the system catalog.

    Henrico Bekker - Tuesday, May 23, 2017 1:55 PM

    Do you see anything in the syscomments table for your procedure when running:
    [code...

    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

    May 24, 2017 at 2:29 am

    #1943937

  • RE: Simulate filling Transaction log

    abhij33t - Tuesday, May 23, 2017 6:00 PM

    It may sound extremely simple and might be it is.... but I am trying 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

    May 24, 2017 at 2:28 am

    #1943936

  • RE: Exclusive PageIOLatch

    Grant Fritchey - Tuesday, May 23, 2017 7:43 AM

    An insert requires that it do an exclusive lock latch on a page in...

    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

    May 24, 2017 at 2:21 am

    #1943934

  • RE: RAM Required to run SQL Server + Web Application + SSIS packages

    Look at how much memory things other than SQL are currently taking.
    Calculate (server memory) - (allocation for OS) - (what other things are using) = starting value for max...

    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

    May 24, 2017 at 2:18 am

    #1943933

  • RE: when creating FK constraint get error 'statement conflicted with [an existing] the FK constraint'

    polkadot - Tuesday, May 23, 2017 2:27 PM

    Does every single FK value in bridge table need to be in parent table?

    Yes, that's...

    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

    May 23, 2017 at 2:48 pm

    #1943893

  • RE: when creating FK constraint get error 'statement conflicted with [an existing] the FK constraint'

    There's data in the tables that violates the constraint you're trying to create, so values in the child table that aren't in the parent table.

    Can you post 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

    May 23, 2017 at 1:15 pm

    #1943875

  • RE: when creating FK constraint get error 'statement conflicted with [an existing] the FK constraint'

    It's not telling you that there's an existing constraint. It's telling you that the data in the table violates the constraint that you're trying to create, and hence that constraint...

    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

    May 23, 2017 at 12:31 pm

    #1943869

  • RE: Are the posted questions getting worse?

    jasona.work - Tuesday, May 23, 2017 8:18 AM

    You know, I'm not sure what fall-weather stuff you could be doing there...

    Finishing up...

    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

    May 23, 2017 at 8:59 am

    #1943817

  • RE: Are the posted questions getting worse?

    jasona.work - Tuesday, May 23, 2017 7:17 AM

    GilaMonster - Tuesday, May 23, 2017 7:01 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

    May 23, 2017 at 7:43 am

    #1943778

  • RE: Are the posted questions getting worse?

    Next long weekend here is 3 weeks away (16th June). Pity, because I could really use an extra day off.

    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

    May 23, 2017 at 7:01 am

    #1943767

  • RE: RAM Required to run SQL Server + Web Application + SSIS packages

    Grant Fritchey - Tuesday, May 23, 2017 6:54 AM

    And, on large scale systems, SQL Server is a very bad kindergartener, it doesn'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

    May 23, 2017 at 7:00 am

    #1943766

  • RE: Password encryption in sql server

    Are you asking about encrypting data and using a password to decrypt it, or about encrypting passwords?

    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

    May 23, 2017 at 5:14 am

    #1943737

  • RE: Which command to reduce log fle ?

    contact 14920 - Tuesday, May 23, 2017 4:34 AM

    Hi Guru,

    Command : dbcc sqlperf(logspace)
    Result : Log Size : 14974.55 / Log Space...

    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

    May 23, 2017 at 4:49 am

    #1943734

  • RE: Database encription - deny access "with execute as" clause

    aar - Monday, May 22, 2017 8:53 AM

    I set it as '%EXECUTE%AS%' so both ways are not allowed 🙂

    Thanks you

    That's going 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

    May 23, 2017 at 2:18 am

    #1943722

  • RE: Service Pack question

    Yes, exactly the same way you'd patch the database engine, patch any portions of SQL Server installed without the DB engine.

    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

    May 23, 2017 at 2:12 am

    #1943720

Viewing 15 posts - 1,411 through 1,425 (of 49,552 total)