What is 268435456?

Question

Post reply

What is 268435456?

Andy Warren

SSC Guru

Points: 119902
More actions
June 26, 2014 at 8:58 pm

#150705

Comments posted to this topic are about the item What is 268435456?
Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
June 27, 2014 at 9:04 am

This was removed by the editor as SPAM

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

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

mickyT SSChampion Points: 10360 More actions · Answer 1

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

pmadhavapeddi22 SSCertifiable Points: 5306 More actions · Answer 2

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

Umer Akram SSC-Insane Points: 22209 More actions · Answer 3

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

rhythmk SSCertifiable Points: 7271 More actions · Answer 4

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
🙂

Tharg SSC Eights! Points: 980 More actions · Answer 5

Related Q.

Where should we *not* find 2147483647 in SQL?

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

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 6

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.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 7

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

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 8

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.

Andy Warren SSC Guru Points: 119902 More actions · Answer 9

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

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter

SQLRNNR SSC Guru Points: 281334 More actions · Answer 10

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

Thomas Abraham SSChampion Points: 10761 More actions · Answer 11

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

Dana Medley SSCertifiable Points: 6764 More actions · Answer 12

Dana Medley

SSCertifiable

Points: 6764

June 27, 2014 at 8:06 am

#1725428

Thanks for the question.

Everything is awesome!

stephen.long.1 SSCrazy Points: 2582 More actions · Answer 13

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.