Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

The Size of the Data Pages in SQL Server Expand / Collapse
Author
Message
Posted Wednesday, July 16, 2014 8:14 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 7:38 AM
Points: 2,658, Visits: 2,083
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."
Post #1593358
Posted Thursday, July 17, 2014 1:03 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:05 PM
Points: 14,174, Visits: 12,157
Nice and easy question, thanks.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1593408
Posted Thursday, July 17, 2014 2:39 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 9:11 AM
Points: 4,333, Visits: 5,703
Nice, straightforward one, thanks.
I have worked with numerous different RDBM's, and the page size is fixed in all of them.


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1593441
Posted Thursday, July 17, 2014 3:17 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Today @ 8:58 AM
Points: 1,451, Visits: 4,917
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
Post #1593446
Posted Thursday, July 17, 2014 3:31 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 9:17 AM
Points: 950, Visits: 1,564
Though, the answer is NO , still wanted to make sure that there no catch or new enhancement in sql server 2014

Post #1593448
Posted Thursday, July 17, 2014 3:41 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 6:50 AM
Points: 964, Visits: 1,659
Good Knowledge base question. Thanks for sharing
Post #1593453
Posted Thursday, July 17, 2014 4:57 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 5:58 AM
Points: 1,883, Visits: 799
twin.devil (7/17/2014)
Good Knowledge base question. Thanks for sharing

Absoulately agree here
Post #1593494
Posted Thursday, July 17, 2014 4:59 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, January 30, 2015 2:00 AM
Points: 259, Visits: 85
a basic concept but it worth to be remembered

Thanks
Post #1593497
Posted Thursday, July 17, 2014 5:48 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:04 PM
Points: 5,202, Visits: 4,669
Good basic question. Thanks.


Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1593542
Posted Thursday, July 17, 2014 8:36 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 3:57 PM
Points: 18,401, Visits: 16,573
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
Post #1593632
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse