What is 268435456?

  • Comments posted to this topic are about the item What is 268435456?

  • Thanks Andy. It's always good to know a bit of trivia, not that this is a trivial number:-)

  • I generally use the below sql for logical name,physical name and path for any db, so this number seemed very familiar, after seeing the question, I have immediately tried the below sql and got the number :-), did not check the other options as the answer is radio button

    select * from sys.sysfiles

  • pmadhavapeddi22 (6/27/2014)


    I generally use the below sql for logical name,physical name and path for any db, so this number seemed very familiar, after seeing the question, I have immediately tried the below sql and got the number :-), did not check the other options as the answer is radio button

    select * from sys.sysfiles

    +1, Nice question. Thanks for sharing

  • Thanks Andy for the question.

    --rhythmk
    ------------------------------------------------------------------
    To post your question use below link

    https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
    🙂

  • Related Q.

    Where should we *not* find 2147483647 in SQL?

    An interesting number! It even has its own Wikipedia page.

  • Thank you Andy, nice one and also made it easy for me just two days ago I was looking into the log file's max_size. 🙂

    (bit confused: how this value 268435456 is equal to 2TB? I mean through conversion)

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • Raghavendra Mudugal (6/27/2014)


    (bit confused: how this value 268435456 is equal to 2TB? I mean through conversion)

    First line in the answer:

    The limit for us humans is 2TB, but SQL stores the limit as the number of 8KB pages!

    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
  • GilaMonster (6/27/2014)


    First line in the answer:

    The limit for us humans is 2TB, but SQL stores the limit as the number of 8KB pages!

    I read that... and also I saw this among other lines in the local_help

    "268435456 = Log file will grow to a maximum size of 2 TB."

    so all of a sudden I thought that number is being somehow converted to 2TB, but missed to link that those the number of pages of 8000 bytes. now it is clear (268435456 * 8000 = 2147483648000 = 2TB)

    Thank you for the pointer, Master. 🙂

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • I'm glad you enjoyed the question, wasn't sure how this one would be received;-)

  • Much simpler than some of the questions from Andy of late. Really straight forward and is something that should be useful to all DBAs.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Like it, and your rhyme at the end! Thanks.

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • Thanks for the question.



    Everything is awesome!

  • This was removed by the editor as SPAM

  • Thanks for the easy question, Andy. I would hate to see a table with 268435456 indexes (let alone 999).

    The rhyme was okay. You should have included it in the question. The QotD is supposed to be fun.

Viewing 15 posts - 1 through 15 (of 26 total)

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