.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

What is the maximum number of records in a table which can be used to build/apply a model

Posted By:      Posted Date: October 14, 2010    Points: 0   Category :Sql Server

Dear All,

I am building an association model , if my nested table records is more than 1 lac, model is failing.

Even same while applying the model also. Server's RAM size is 16GB.

Please can you suggest the maximum number of records that can be handled?

Thanks in Advance

View Complete Post

More Related Resource Links

Getting the total number of records in a database table?


How could I get the total number of records present in a database table through asp.net in VB? I know about setting up and opening a connection. I wanted to loop through records, so wanted to know the number of records present. How could that be done? 

Also, I used statements like 'Update' and 'Insert Into' to to change the data in my data source. Like I updated a certain field like this:

ds.Tables("tblUsers").Rows(2)(3) = "xyzzzz" 

and then I executed an sql statement on the same field like this: 

objCmd.UpdateCommand = new OleDbCommand

objCmd.UpdateCommand.CommandText = "Update tblUsers " & _

"SET City='xyzzzz' WHERE UserID=3"  

objCmd.UpdateCommand.Connection = Conn


(where objcmd is an instance of oledbdataadapter object)

What should I do to delete a record or a field in a data source through asp.net?

What's the Realistic Maximum Number of Index per Table


What is a good real world maximum(so i am not looking for this answer:http://blog.sqlauthority.com/2009/06/29/sql-server-maximum-number-of-index-per-table/) for the number of indexes on a table (table has around 50 columns and at the moment 3 indexes)

. I would like to add 3 more indexes on fields that are not used for joining but are searched upon lots of the time. Is this a good idea?

Populate tree from self joined table with number of child records?




ID           | NAME         | PARENTID

1           A                0

2           B                0

3           A.1             1

4           A.2             1

5           A.1.1          3

6           B.1             2

7           B.1.1          6

8           B.1.1.1       7


Select number of records from table


I get records from the table by using "Select top(5) itemCode,ItemName,Price from Item"

Now I wan't to take next 5 records. How can I create query to that one.

After that I wan't to take the previous 5 records also.

SQL ERROR : showing maximum records 9 even if more than 10 records exist in table!!


hiii guys,,

i dont know how to deal with this error. i have 4 tables. each with equal and same columns. all tables have more than 10 records. when i fire a query to find out maximum records , it shows only 9. datatype used is varchar. and since this is very crucial as it is used as primary key and its a student id which gets incremented every time a new student adds to the 4 tables(in vb.net). my whole project is stuck cos of this. if i get this i have no other work to complete for my project.it will be over.


front end is vb.net

back end is sql.


i want that everytime when user inserts an entry and press a button,he should get student id + 1 from the existing.but it is only showing me 9records and always there's a ambiguity of 10th record in database..


guys pls help out of this!!!!

Whistler: Build More Flexible Console Snap-ins with the MMC 2.0 Object Model


Microsoft Management Console (MMC) 2.0 provides a host of exciting new features for MMC users and snap-in developers. The new MMC 2.0 automation object model allows much of the user interface of MMC 2.0 to be accessed through script, and exposes events so that many tasks can now easily be automated. The new view extension model uses HTML to enable extensions to seamlessly integrate new user interfaces with those of existing snap-ins. MMC 2.0 also includes a specific view extension snap-in, the Extended View snap-in, which provides an interface similar to Web folders. Drag and drop support has been expanded, and console files now use the XML file format. Enhancements to console taskpads make it easier to accomplish tasks.

Vivek Jhaveri

MSDN Magazine March 2001

Entity Data Model and database view returning the same columns as there are in a table


When adding a stored procedure into the Entity Data Model I can select whether the procedure returns a scalar, a (new) complex type or one of the entity types I already defined. 

How do I do something similar for a view?

I mean assuming I have a view like this

CREATE VIEW FilteredFoos as SELECT Foo.* FROM Foo join ... WHERE ...

(that is a view that implements some involved filtering, but returns all columns from one table) how do I add it to the project so that I can use the entity set, but get the Foo objects, not some new FilteredFoo objects.

var foos = myDB.FilteredFoos.Include("Bar").ToList();

foreach (Foo foo in foos) { ...

Thanks, Jenda

Model Binding the values in an HTML Table back to Controller / Model


Currently, I am working with ASP.NET MVC1 and am still learning about Model Binding and how values from a View are passed back to the Controller / Model. Specifically, I want take an existing Model, create a Table and populate the Rows of the Table, allow the user to edit some fields and pass it back.

In my example, I have a Class called "Ingredient" which has 4 public accessors:  Name, Barcode, Amount, and Unit

<%@ Page Title="" Language="C#" MasterPageFile="~/Views/Shared/Site.Master" Inherits="System.Web.Mvc.ViewPage<IEnumerable<MvcACE.DomainModel.Entities.Ingredient>>" %>

<% using (Html.BeginForm("SubmitOrder","MyController"))
{ %>

<% if (Model != null)
foreach (var item in Model)
{ %>
<td><%= Html.Encode(item.Name)%></td>
<td><%= Html.Encode(item.Barcode)%></

Maximum Number of Processor Cores in CLR

Is the maximum number of processors (cores) supported by different versions of the CLR documented somewhere?  I'm working on an application hang problem and I can see in dumps that a thread is waiting in mscorwks!ThreadpoolMgr::RecycleMemory for a flag whose address was calculated by using the processor number as an index.  I can't see the index in the dump, but the machine has 48 processors and it looks as though the array containing the flags can accomodate only 32 processors, so the thread might be waiting on something beyond the array. Another clue is that there are only 32 GC threads, so I'm suspicious that this CLR will only scale to 32 cores. The CLR in use is the 32-bit version of 2.0 running on 64-bit Windows 2008 SP2.  I'd like to see whether there is a restriction on the number of processors in that version and, if so, whether there is another version that would support more.

Duplicate records find in table

  Hi ALL, I want to find the dynamically check the primary key values and remove the duplicate records.. please suggest it.   Regards Ram

Selecting different no. of records from the same table

Hello all, This might seem a basic thing but bothering me from last few days. Suppose I have a table containing 5 million records and I am running queries one by one (one query executes completly and then next query is fired)as below on that table. SELECT top 20000 FROM MyTable SELECT top 200000 FROM MyTable SELECT top 2000000 FROM MyTable  Now my questions are; Will SQL Server use same execution plan? As I am running these queries one by one in same order as given above, will second query take less time than it should if run standalone (only second query is fired, no query fired before that) and similarly will third query take less time than it should if run standalone (only third query is fired, no query fired before that), since there is a possibility of same execution plan being used?  Regards.    

I have relation many to many - how can I delete records from intermediate table ?

I have tables: Books id title Authors id name BooksAuthors book_id author_id Entity Framework generated only models for tables Books and Authors in relation many to many. How can I delete from table BooksAuthors all records where book_id =5 ?

Get the count of the recently added records to a table

i need to create 2 temporary tables. The records inserted into the 2nd table is the same as that from table1. Now, i am inserting some other records into table 2.what i need is, to retrieve the count of the recently added records into table2.How to achieve this? 

Cannot Insert records in table using NHibernate

I am very much new with NHibernate. I am inserting a new record in the table. However, it seems that it does not insert. What I'm using is Fluent NHibernate.Below is the code which inserts records. public virtual void Save(string CreatedBy) { ISession NHSession = Star.CNPL_BusinessObjects.Common.Session.OpenSession(); ITransaction NHTransaction = NHSession.BeginTransaction(); try { this.Save(CreatedBy, NHSession); NHTransaction.Commit(); NHSession.Flush(); } catch (Exception ex) { NHTransaction.Rollback(); throw ex; } } public virtual void Save(string CreatedBy, ISession Session) { try { if (this.IsPersisted) { this.SaveAuditTrail(Session, false, CreatedBy); Session.SaveOrUpdateCopy(this); } else { Session.Save(this); } } catch (Exception ex) { throw ex; } }

Upload millions of file records to a table

I have six input files having millions of record. I need to upload these data to my table. How can I upload the details in the most efficient way. Any help on this will be greatly appreciated.

How to apply color to selected number of items in check box list and drop downlist

Hi all,    I want to apply color to selected number of items in checkbox list and seleted number of items in drop downlist for e.g color red for few items and black (default). I have a bit value set in data base so if bit is set to 0 then red and if 1 then back. Please help me.  

Problem with listing records from table (object not found)

Hi everyone, I'm creating a website based on ASP.NET MVC 2 and SQL Server 2008 R2 Express for the database. After creating the table in database, I want to list all records in that table. For that, I use "scaffold'ing in ASP.NET to automatically generate the view file. But I encountered an error when loading that page. The error message was: [CODE] Server Error in '/' Application. Invalid object name 'dbo.Accommodations'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'dbo.Accommodations'. Source Error: Line 41:         </tr> Line 42: Line 43:     <% foreach (var item in Model) { %> Line 44: Line 45:         <tr> Source File: d:\MyProject\Views\Accommodation\Index.aspx    Line: 43 Stack Trace: [SqlException (0x80131904): Invalid object name 'dbo.Accommodations'.]    System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +2030802    System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5009584 &n
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend