InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 19:55:47 GMT20http://www.sqlservercentral.com/Forums/Topic1390455-391-1.aspx[quote][b]GilaMonster (11/30/2012)[/b][hr]SQL Server 2008 Internals by Kalen DelaneyPaul Randal's blog.[/quote]Thanks Gail.Sun, 02 Dec 2012 22:25:14 GMTsanket kokanehttp://www.sqlservercentral.com/Forums/Topic1390455-391-1.aspxSQL Server 2008 Internals by Kalen DelaneyPaul Randal's blog.Fri, 30 Nov 2012 06:45:52 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1390455-391-1.aspxthanks for clearing out :-)any other good link/eBook related to architecture other than MSDN ?Fri, 30 Nov 2012 05:58:01 GMTsanket kokanehttp://www.sqlservercentral.com/Forums/Topic1390455-391-1.aspx[quote][b]sanket kokane (11/30/2012)[/b][hr][quote][b]ScottPletcher (11/29/2012)[/b][hr]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).[/quote]you sounds like only one row per page ,right ?[/quote]No, he said each row resides on a single page, not each page contains only one row.Fri, 30 Nov 2012 05:44:34 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1390455-391-1.aspxNo as the row is not bigger than 8060 bytes to use row overflow[quote]Rows cannot span pages,[/quote][quote]This restriction is relaxed for tables that contain varchar, nvarchar, varbinary, or sql_variant columns. [b]When the total row size of all fixed and variable columns in a table exceeds the 8,060 byte limitation[/b], SQL Server dynamically moves one or more variable length columns to pages in the ROW_OVERFLOW_DATA allocation unit, starting with the column with the largest width. This is done whenever an insert or update operation increases the total size of the row beyond the 8060 byte limit. [/quote]Fri, 30 Nov 2012 05:18:00 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1390455-391-1.aspx[quote][b]anthony.green (11/30/2012)[/b][hr]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.[/quote]sorry if I not ask my doubt clearlymy 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 ? Fri, 30 Nov 2012 05:12:58 GMTsanket kokanehttp://www.sqlservercentral.com/Forums/Topic1390455-391-1.aspxNo 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.Fri, 30 Nov 2012 05:02:48 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1390455-391-1.aspx[quote][b]anthony.green (11/30/2012)[/b][hr][quote][b]sanket kokane (11/30/2012)[/b][hr][quote][b]ScottPletcher (11/29/2012)[/b][hr]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).[/quote]you sounds like only one row per page ,right ?[url]http://msdn.microsoft.com/en-us/library/ms190969%28v=sql.105%29.aspx[/url][quote]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.[/quote]I think remaining space can be used by other rows .Please can you share any link related it ?[/quote]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.[/quote]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?Fri, 30 Nov 2012 04:58:04 GMTsanket kokanehttp://www.sqlservercentral.com/Forums/Topic1390455-391-1.aspx[quote][b]sanket kokane (11/30/2012)[/b][hr][quote][b]ScottPletcher (11/29/2012)[/b][hr]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).[/quote]you sounds like only one row per page ,right ?[url]http://msdn.microsoft.com/en-us/library/ms190969%28v=sql.105%29.aspx[/url][quote]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.[/quote]I think remaining space can be used by other rows .Please can you share any link related it ?[/quote]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.Fri, 30 Nov 2012 04:45:26 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1390455-391-1.aspx[quote][b]ramyours2003 (11/29/2012)[/b][hr]HOW MANY datapages in sql ?[/quote][quote][b]Sean Lange (11/29/2012)[/b][hr]Everybody knows this is 42 :-P[/quote]No, you're wrong, they changed it! It's 321 since Thanksgiving!:w00t: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 :-DThat would be a great question for Question Of The Day...Fri, 30 Nov 2012 04:45:14 GMTEugene Elutinhttp://www.sqlservercentral.com/Forums/Topic1390455-391-1.aspx[quote][b]ScottPletcher (11/29/2012)[/b][hr]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).[/quote]you sounds like only one row per page ,right ?[url]http://msdn.microsoft.com/en-us/library/ms190969%28v=sql.105%29.aspx[/url][quote]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.[/quote]I think remaining space can be used by other rows .Please can you share any link related it ?Fri, 30 Nov 2012 04:34:14 GMTsanket kokanehttp://www.sqlservercentral.com/Forums/Topic1390455-391-1.aspxDepends 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.Thu, 29 Nov 2012 15:14:02 GMTScottPletcherhttp://www.sqlservercentral.com/Forums/Topic1390455-391-1.aspxEverybody knows this is 42 :-PThu, 29 Nov 2012 08:42:54 GMTSean Langehttp://www.sqlservercentral.com/Forums/Topic1390455-391-1.aspxHuh?What are you asking?Thu, 29 Nov 2012 05:52:44 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1390455-391-1.aspxHOW MANY datapages in sql ?Thu, 29 Nov 2012 05:35:15 GMTramyours2003