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: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
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 @ 8:15 AM
Points: 13,017, Visits: 10,800
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


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 6:46 AM
Points: 3,982, Visits: 5,228
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
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 12:14 PM
Points: 1,043, Visits: 3,345
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: Thursday, September 25, 2014 12:36 AM
Points: 805, Visits: 1,404
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
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

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


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 11:45 PM
Points: 1,280, Visits: 608
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: Thursday, July 17, 2014 4:57 AM
Points: 239, Visits: 69
a basic concept but it worth to be remembered

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

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 9:31 AM
Points: 4,036, Visits: 3,470
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 @ 9:14 AM
Points: 17,704, Visits: 15,566
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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1593632
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse