The Size of the Data Pages in SQL Server

Question

The Size of the Data Pages in SQL Server

free_mascot

One Orange Chip

Points: 27169
More actions
July 16, 2014 at 8:14 pm

#291163

Comments posted to this topic are about the item The Size of the Data Pages in SQL Server
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
July 17, 2014 at 2:39 am

This was removed by the editor as SPAM

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

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

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

Nice and easy question, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Neil Burton SSC-Insane Points: 22999 More actions · Answer 2

It was so easy it took at least 20 minutes research to make sure there wasn't a catch. I must have checked half the documentation and writing about page sizes to find a 'but in this case...'.

On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher

How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

pmadhavapeddi22 SSCertifiable Points: 5306 More actions · Answer 3

Though, the answer is NO , still wanted to make sure that there no catch or new enhancement in sql server 2014 🙂

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

Umer Akram

SSC-Insane

Points: 22209

July 17, 2014 at 3:41 am

#1730162

Good Knowledge base question. Thanks for sharing

Hany Helmy SSChampion Points: 13921 More actions · Answer 5

twin.devil (7/17/2014)
Good Knowledge base question. Thanks for sharing

Absoulately agree here 😎

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

domenico.delbrocco SSChasing Mays Points: 617 More actions · Answer 6

domenico.delbrocco

SSChasing Mays

Points: 617

July 17, 2014 at 4:59 am

#1730190

a basic concept but it worth to be remembered

Thanks

Ed Wagner SSC Guru Points: 287026 More actions · Answer 7

Good basic question. Thanks.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

SQLRNNR SSC Guru Points: 281334 More actions · Answer 8

domenico.delbrocco (7/17/2014)
a basic concept but it worth to be remembered
Thanks

+1

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

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 9

Thank you for the post, very interesting one.

I had an idea on 8k size but never had an idea that there will-be/can-be a change option or can be changed and was wondering if it really can?... I had my doubts and I went with NO.... well; 🙂

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

William Clardy SSChasing Mays Points: 627 More actions · Answer 10

Stewart "Arturius" Campbell (7/17/2014)
Nice, straightforward one, thanks.
I have worked with numerous different RDBM's, and the page size is fixed in all of them.

Which in my mind begs the question of "Why?"

To cite another T-SQL RDBMS, Sybase's Advanced SQL Anywhere allows you to select the page size at database-creation time , with page size options up to 32KB. Obviously, bigger pages can have a significant impact on the I/O overhead, and Sybase's making it an option independent of the CPU type would seem to put the lie to claims of the restriction being necessary for "backward compatibility" with unnamed CPUs.

Revenant SSC-Forever Points: 42467 More actions · Answer 11

Revenant

SSC-Forever

Points: 42467

July 17, 2014 at 2:35 pm

#1730449

Supereasy! Thanks!

free_mascot One Orange Chip Points: 27169 More actions · Answer 12

Thank you and appreciate all your time and interest in writing comments.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

paul.knibbs SSCoach Points: 15320 More actions · Answer 13

william-700725 (7/17/2014)Sybase's making it an option independent of the CPU type would seem to put the lie to claims of the restriction being necessary for "backward compatibility" with unnamed CPUs.

Yeah, that CPU page size explanation makes no sense whatsoever, especially since the x86 CPU line (which is obviously SQL Server's primary home) doesn't use 8Kb pages! They used to be 4Kb in the 386 and 486, then they added an option for 4Mb pages in the Pentium, and I think x86-64 CPUs add a 1Gb page option as well.