Post reply

Count(*)

  • November 17, 2009 at 4:53 pm

    #1080621

    It's sinking below the top, still .. hoping to get response ..

    Anyone from the dark guides me through the dark ?

    Thanks.

  • November 18, 2009 at 12:18 am

    #1080705

    1b. Probably, but why would you want to use MAX? Jason posted showing a couple of queries for getting the row counts from sys.partitions.

    2. Don't understand the question. Order of writes is log file first then data file.

    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 18, 2009 at 4:51 pm

    #1081298

    Thanks again first.

    1. If there is only one index (no partitioned table) allowed, MAX(rows) would get the "count(*)" provided other indexes are zero. Just want to clarify/learn for curiosity.

    2. LOG --> file--> is it next to system table(s) updating like those tables mentioned?

    Salute !

  • November 19, 2009 at 3:05 am

    #1081417

    1) Probably.

    2) Still don't understand what you're asking. When a transaction occurs, all necessary changes are made in memory. When the transaction is completed, the changes are hardened into the log. At a later time, those changes in memory are written to disk.,

    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 19, 2009 at 12:40 pm

    #1081790

    Thanks!

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply