Forum Replies Created

Viewing 15 posts - 16,951 through 16,965 (of 49,552 total)

  • RE: what is CPU ? Physical or logical ?

    8. It's the number visible in task manager in Windows (unless you've configured SQL to use fewer processors)

    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 26, 2012 at 4:38 am

    #1530103

  • RE: dead connection detection

    jessh (8/25/2012)

    They can also be a basis for distributed negotiation, of course. Unfortunately, SQL Server seems ill suited to such usage because there's no mechanism for it to recognize...

    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 26, 2012 at 4:36 am

    #1530102

  • RE: dead connection detection

    If the connection drops (and if the client goes away it will drop) any open transactions get rolled back. As a result of that rollback any locks are released.

    Test 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 25, 2012 at 3:58 pm

    #1530088

  • RE: microsoft certification dba

    Any order you like.

    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 25, 2012 at 2:08 pm

    #1530084

  • RE: microsoft certification dba

    I don't usually register for an exam until I'm happy that I'm ready for it. Usually just a couple weeks in advance. Least I ever did was register 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 25, 2012 at 1:32 pm

    #1530079

  • RE: microsoft certification dba

    Here's the info on the certs and exams: http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx

    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 25, 2012 at 9:30 am

    #1530059

  • RE: sql server CONFIG statement cannot be used inside a user transaction

    Just one point.

    Reconfigure With Override tells SQL not to check that the values you've specified are sensible and valid values. It allows you to set options to values that will...

    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 24, 2012 at 4:02 pm

    #1529991

  • RE: Are the posted questions getting worse?

    It's potential energy is negative to the entire universe.

    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 24, 2012 at 3:56 pm

    #1529990

  • RE: Nested Loops Joins

    erics44 (8/23/2012)

    I have been lokoing at Nested Loop Joins and i probably dont fully understand them but how can this benefit as opposed to just using a regular join?

    Nested loops,...

    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 24, 2012 at 12:29 pm

    #1529910

  • RE: Fragementation at index_level 1 and beyond

    Maybe. Not likely, but it is possible.

    Requires that the table get large enough range scans that the read-ahead has to drive the scan from two levels up the index (probably...

    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 24, 2012 at 12:22 pm

    #1529904

  • RE: parellel spid identification

    sys.dm_exec_query_stats.

    Not estimated, aggregated actual performance statistics. There would be no point in estimated reads.

    There shouldn't be multiple plans for a procedure, unless it gets called from apps with different set...

    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 24, 2012 at 12:09 pm

    #1529897

  • RE: Right, I've had enough of poorly-written practice questions!

    Scott D. Jacobson (8/24/2012)

    In standardized tests like these, the test is looking for the MOST correct answer. While the other 2 are correct, they may not be as correct...

    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 24, 2012 at 11:32 am

    #1529883

  • RE: Right, I've had enough of poorly-written practice questions!

    derek.colley (8/24/2012)

    Which presumably means that if the database was located to an instance with a different collation setting, all database, table/object and column levels of collation would achieve this effect....

    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 24, 2012 at 11:13 am

    #1529870

  • RE: parellel spid identification

    BaldingLoopMan (8/24/2012)

    Theoretically if a plan is cached badly for whatever reason one day, is it safe to assume that the size of cached plan in bytes will grow relative...

    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 24, 2012 at 11:06 am

    #1529868

  • RE: Are the posted questions getting worse?

    Jeff Moden (8/24/2012)

    GilaMonster (8/24/2012)

    Jeff Moden (8/23/2012)

    GilaMonster (8/23/2012)

    Data archiving. Can't use partition swaps because it's standard edition.

    Have you considered partitioned views?

    Create a new table every month, alter the view to include...

    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 24, 2012 at 10:13 am

    #1529848

Viewing 15 posts - 16,951 through 16,965 (of 49,552 total)