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»»

pages Expand / Collapse
Author
Message
Posted Thursday, November 29, 2012 5:35 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Saturday, July 26, 2014 2:17 AM
Points: 521, Visits: 2,006
HOW MANY datapages in sql ?
Post #1390455
Posted Thursday, November 29, 2012 5:52 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 11:54 AM
Points: 42,466, Visits: 35,530
Huh?

What are you asking?



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #1390469
Posted Thursday, November 29, 2012 8:42 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:18 PM
Points: 13,110, Visits: 11,942
Everybody knows this is 42

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1390617
Posted Thursday, November 29, 2012 3:14 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 10:12 AM
Points: 1,970, Visits: 2,909
Depends on how many bytes in table, and how long a row is.

A SQL page is 8K, with 8060 total bytes available for data. Each row resides on a single page (excluding special column types).

So if every row takes, say, 4100 bytes, each would take a whole page, with the rest of that page unuseable except to expand the existing row.


SQL DBA,SQL Server MVP('07, '08, '09)
"In America, every man is innocent until proven broke!" Brant Parker
Post #1390887
Posted Friday, November 30, 2012 4:34 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, August 1, 2013 10:17 AM
Points: 323, Visits: 984
ScottPletcher (11/29/2012)
Depends on how many bytes in table, and how long a row is.

A SQL page is 8K, with 8060 total bytes available for data. Each row resides on a single page (excluding special column types).



you sounds like only one row per page ,right ?

http://msdn.microsoft.com/en-us/library/ms190969%28v=sql.105%29.aspx


So if every row takes, say, 4100 bytes, each would take a whole page, with the rest of that page unuseable except to expand the existing row.


I think remaining space can be used by other rows .

Please can you share any link related it ?


-----------------------------------------------------------------------------
संकेत कोकणे
Post #1391207
Posted Friday, November 30, 2012 4:45 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, July 4, 2014 3:55 AM
Points: 2,836, Visits: 5,062
ramyours2003 (11/29/2012)
HOW MANY datapages in sql ?


Sean Lange (11/29/2012)
Everybody knows this is 42


No, you're wrong, they changed it! It's 321 since Thanksgiving!


They may cut it back to 238, there is still discussion in a senate. Republicans want it to be cut down! Let's pray for Obama

That would be a great question for Question Of The Day...


_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!"
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help
Post #1391216
Posted Friday, November 30, 2012 4:45 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:51 AM
Points: 5,142, Visits: 4,937
sanket kokane (11/30/2012)
ScottPletcher (11/29/2012)
Depends on how many bytes in table, and how long a row is.

A SQL page is 8K, with 8060 total bytes available for data. Each row resides on a single page (excluding special column types).



you sounds like only one row per page ,right ?

http://msdn.microsoft.com/en-us/library/ms190969%28v=sql.105%29.aspx


So if every row takes, say, 4100 bytes, each would take a whole page, with the rest of that page unuseable except to expand the existing row.


I think remaining space can be used by other rows .

Please can you share any link related it ?


As long as the second row is 3900 bytes or less.

The example was that if every row takes 4100 bytes, so that would mean that only 1 row can be stored on a page, the remaining 3900 bytes could only ever be used by the row occuping the page.




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1391217
Posted Friday, November 30, 2012 4:58 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, August 1, 2013 10:17 AM
Points: 323, Visits: 984
anthony.green (11/30/2012)
sanket kokane (11/30/2012)
ScottPletcher (11/29/2012)
Depends on how many bytes in table, and how long a row is.

A SQL page is 8K, with 8060 total bytes available for data. Each row resides on a single page (excluding special column types).



you sounds like only one row per page ,right ?

http://msdn.microsoft.com/en-us/library/ms190969%28v=sql.105%29.aspx


So if every row takes, say, 4100 bytes, each would take a whole page, with the rest of that page unuseable except to expand the existing row.




I think remaining space can be used by other rows .

Please can you share any link related it ?


As long as the second row is 3900 bytes or less.

The example was that if every row takes 4100 bytes, so that would mean that only 1 row can be stored on a page, the remaining 3900 bytes could only ever be used by the row occuping the page.




what if second row size > 3900 int this case .
Row overflow can take place or not ?

or it will go directly to the another new page?


-----------------------------------------------------------------------------
संकेत कोकणे
Post #1391221
Posted Friday, November 30, 2012 5:02 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:51 AM
Points: 5,142, Visits: 4,937
No as it has to be the row which overflows, not the page. The row is not overflowing as its 4100 bytes, for row overflow to occur the whole row must be > 8060 bytes.



Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1391224
Posted Friday, November 30, 2012 5:12 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, August 1, 2013 10:17 AM
Points: 323, Visits: 984
anthony.green (11/30/2012)
No as it has to be the row which overflows, not the page. The row is not overflowing as its 4100 bytes, for row overflow to occur the whole row must be > 8060 bytes.

sorry if I not ask my doubt clearly
my first row size = 4100
(Remaining page size = 3960)
my second row size = 5000
(extra byte 1040)
so cant my second row stored on same page as of first row ? and overflowing my second row remaining bytes to new page ?


-----------------------------------------------------------------------------
संकेत कोकणे
Post #1391229
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse