Forum Replies Created

Viewing 15 posts - 14,956 through 14,970 (of 49,552 total)

  • RE: Phd Suggestions

    saranya.priyadharshini (1/6/2013)

    Hi,

    Planning to go ahead with Phd in Database Admin, Kindly provide some suggestions on it...

    More efficient topic for research area is Perfomance Analysis using extended events ...

    If...

    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

    January 7, 2013 at 3:22 am

    #1574231

  • RE: Inline transaction not committing properly

    matthew.peters (1/6/2013)

    What I dont understand is why does it work on one database and not the other, is there a specific configuration setting that would effect this?

    No, no config 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

    January 7, 2013 at 3:18 am

    #1574230

  • RE: Analyst seeking wisdoms while learning the platform

    vega805 (1/6/2013)

    I see. So for building forms, the front end to database solutions, which one is used?

    Well, since ASP.Net uses .Net, that's kinda a moot question, but...

    Desktop Apps, some .Net...

    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

    January 7, 2013 at 3:17 am

    #1574227

  • RE: Inline transaction not committing properly

    matthew.peters (1/6/2013)

    This is all part of 1 transaction, so what I can see is happening is that the alter table statements are not committing before the insert statements.?

    The committing 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

    January 6, 2013 at 6:31 pm

    #1574157

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (1/6/2013)

    GilaMonster (1/6/2013)

    Stefan Krzywicki (1/5/2013)

    In this galaxy, the laws of physics are different (the best explanation of, well, everything in Star Wars) and space there is not the (almost)...

    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

    January 6, 2013 at 3:23 pm

    #1574147

  • RE: Index rebuild fragmentation criteria confusion

    Bhuvnesh (1/6/2013)

    external fragmentation is basically handled by sql server internally

    No, it's not. Fixing 'external fragmentation' requires an index rebuild or index reorganise.

    and data get inserted in mixed extent initially...

    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

    January 6, 2013 at 2:07 am

    #1574110

  • RE: Index rebuild fragmentation criteria confusion

    Yuri55 (1/5/2013)

    It makes sense to consider internal fragmentation while making decision to rebuild indexes- why in this case majority scripts/advices (including mentioned BOL sample) do not care about it (only...

    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

    January 6, 2013 at 2:04 am

    #1574109

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (1/5/2013)

    In this galaxy, the laws of physics are different (the best explanation of, well, everything in Star Wars) and space there is not the (almost) void that 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

    January 6, 2013 at 2:01 am

    #1574107

  • RE: (Restoring...) question

    Run

    RESTORE DATABASE <database name> WITH RECOVERY

    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

    January 5, 2013 at 3:28 pm

    #1574085

  • RE: Performance issue due to high memory usage

    SQLCrazyCertified (1/5/2013)

    So, if I understand you correctly, if SQL uses all the memory which is allocated to it, then SQL will not have enough memory to work on other outstanding...

    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

    January 5, 2013 at 3:22 pm

    #1574083

  • RE: Replacing fixed data in a WHERE clause with dynamic data

    michael.newman560 (1/5/2013)

    I assume that the two statements directly below the procedure name, "@inFromDate" and "@inToDate" are just two variables for the WHERE clause to use. Where do they get...

    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

    January 5, 2013 at 10:19 am

    #1574057

  • RE: Analyst seeking wisdoms while learning the platform

    vega805 (1/4/2013)

    Thank you for the input Sean, Yes I want to be current. Dumb question but .NET and ASP.NET the same thing?

    No.

    .NET = set of libraries plus compiler and runtime

    ASP.Net...

    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

    January 5, 2013 at 7:57 am

    #1574043

  • RE: Index fregment doesn't come to 0

    First problem

    KcV (1/5/2013)

    ---- Set Recovery Mode SIMPLE

    Begin

    ALTER DATABASE aaa

    ...

    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

    January 5, 2013 at 1:55 am

    #1574028

  • RE: Are the posted questions getting worse?

    wolfkillj (1/4/2013)

    jasona.work (1/4/2013)

    jcrawf02 (1/4/2013)

    hahaha

    http://datacenterdesign.datacenterreports.com/~/media/Files/Data%20Center%20Reports/Defending%20the%20Death%20Star%20with%20a%20Little%20Data%20Center%20Design%20-%20Full%20Size.ashx

    But they're cheating! They're mixing up stuff from Death Star 1 (Star Wars: A New Hope) and Death Star 2 (Star Wars: Return / Revenge of...

    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

    January 5, 2013 at 1:50 am

    #1574027

  • RE: Record locking

    Yup, that's an alternative way of doing things. Your original version we would call pessimistic concurrency (I expect someone else to try to change the same data, hence I'll lock...

    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

    January 5, 2013 at 1:48 am

    #1574026

Viewing 15 posts - 14,956 through 14,970 (of 49,552 total)