Forum Replies Created

Viewing 15 posts - 856 through 870 (of 49,552 total)

  • RE: Are These Two Code Fragments Equal?

    There is no login on my pc. I do not enter a user id or password. Since it was my app that created those named transactions then it would...

    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

    August 23, 2017 at 6:51 am

    #1956361

  • RE: Are These Two Code Fragments Equal?

    Also, what permissions does the account that the app uses have?

    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

    August 23, 2017 at 4:36 am

    #1956342

  • RE: Are These Two Code Fragments Equal?

    The transaction is started on the client side. This is the code for the TransactionExists UDF. The others just look specifically for Add or Edit instead of either one.

    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

    August 23, 2017 at 4:35 am

    #1956341

  • RE: Are These Two Code Fragments Equal?

    What's the definition of the functions?
    And where do you start the transaction?

    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

    August 23, 2017 at 4:09 am

    #1956336

  • RE: Are These Two Code Fragments Equal?

    Hi Guys,

    I'm kind of stumped here and could use another set of eyes. I've got two pieces of code that are supposed to do 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

    August 23, 2017 at 2:24 am

    #1956325

  • RE: Version store does not support page compression

    Why are you asking? What problem are you trying to solve that you need to ask that question here and in other places?

    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

    August 22, 2017 at 11:42 am

    #1956217

  • RE: Fill in missing gaps on intergers

    Google: "Gaps and Islands", the best stuff will probably be by Itzik Ben-Gan

    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

    August 22, 2017 at 6:55 am

    #1956141

  • RE: SQL Database corruption issue

    Tail log is to ensure that absolutely nothing is missed, taking it switches the source DB into RESTORING state, so that nothing more can be done to it.

    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

    August 22, 2017 at 5:36 am

    #1956125

  • RE: Location options for data and indexes

    Eliyahu - Tuesday, August 15, 2017 9:45 AM

    I still have a lot of room on D:. I will place some data tables...

    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

    August 22, 2017 at 5:35 am

    #1956124

  • RE: Query optimization - Select Into .. Alter Table ADD CONSTRAINT PRIMARY KEY ([ID] ASC)

    Please post the full query, its execution plan and the definition of the tables it references and the indexes on those tables.

    We can't tune a query from seeing...

    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

    August 22, 2017 at 5:25 am

    #1956119

  • RE: Version store does not support page compression

    Probably because the CPU overhead and slowdown from such compression would be unacceptable.

    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

    August 22, 2017 at 2:00 am

    #1956091

  • RE: 2008 R2 - ConnectionProperty system function is missing.

    johng-842937 - Wednesday, August 16, 2017 9:57 AM

    Trying to do updates to a client DB we have discovered that the System Functions...

    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

    August 21, 2017 at 2:05 pm

    #1956063

  • RE: Are the posted questions getting worse?

    Sean Lange - Monday, August 21, 2017 1:26 PM

    We were able to catch a few glimpses at about 30-35% but before...

    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

    August 21, 2017 at 1:40 pm

    #1956057

  • RE: SQL Database corruption issue

    john.round - Monday, August 21, 2017 7:45 AM

    So just to confirm the first log after that is at 01:00, then on 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

    August 21, 2017 at 11:58 am

    #1956041

  • RE: Need to find a store procedure in a database

    Yes, but since the XML tags are generated from data, you need to search for a query that runs against whatever table has those columns in, and has the FOR...

    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

    August 21, 2017 at 6:16 am

    #1955966

Viewing 15 posts - 856 through 870 (of 49,552 total)