InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 05:35:45 GMT20http://www.sqlservercentral.com/Forums/Topic621764-145-1.aspxWhy on earth would you need millions of records in a front-end app? People won't even read thousands of records. Most people don't go past the first screen, except to go to the last screen to look at totals, which you could provide independently.BTW, Open your local copy of Books Online and past this into it (ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10sq_GetStart/html/13e95046-0e76-4604-b561-d1a74dd824d7.htm). That shows you all the maximum values.Thu, 18 Dec 2008 06:37:33 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic621764-145-1.aspx1. The maximum size is limited by Int32. So 2^32 is the maximum number of DataTables you can hold inside a DataSet. So the max size is 2 billion.2. The maximum number of rows that a DataTable can store is 16,777,2163. The maximum number of columns per base table is 1024.Wed, 17 Dec 2008 23:51:20 GMTjchandramoulihttp://www.sqlservercentral.com/Forums/Topic621764-145-1.aspxwhat is the max. number of tables we can store in a datasetwhat is the max. number of rows we can store in a dataset tablewhat is the max. number of columns we can store in a dataset tableAlso if i have some millions of records in the db, is it an efficient mechanism to transfer the records to the front end in a single dataset or is there any other mechanism we need to adopt.Wed, 17 Dec 2008 21:23:32 GMTharish_ravi