Dataset doubt

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Development » Dataset doubt

Dataset doubt

Rate Topic

Display Mode

Topic Options

Author

Message

harish_ravi

Posted Wednesday, December 17, 2008 9:23 PM

Grasshopper

Group: General Forum Members
Last Login: Sunday, August 09, 2009 11:55 PM
Points: 24, Visits: 76

what is the max. number of tables we can store in a dataset
what is the max. number of rows we can store in a dataset table
what is the max. number of columns we can store in a dataset table

Also 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.

Post #621764

jchandramouli

Posted Wednesday, December 17, 2008 11:51 PM

SSC Rookie

Group: General Forum Members
Last Login: Monday, December 20, 2010 4:47 AM
Points: 42, Visits: 141

1. 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,216

3. The maximum number of columns per base table is 1024.

"I Love Walking In The Rain So No One Can See Me Crying ! " ~ Charlie Chaplin

Post #621806

Grant Fritchey

Posted Thursday, December 18, 2008 6:37 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 8:20 AM
Points: 13,381, Visits: 25,167

Why 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.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #622003

« Prev Topic | Next Topic »

Permissions