limitation records - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

limitation records

Author

Topic

Tirez
Starting Member

13 Posts

Posted - 2011-12-21 : 21:52:18

i have question about maximum records that in SQL Server can be load? or there are not limitation for that, so it can be run normally because in MS Access there is.

X002548
Not Just a Number

15586 Posts

Posted - 2011-12-21 : 22:06:40

Is this a quiz...?

Can you tell us home many rows? How Many Columns?

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-22 : 01:41:41

quote:
Originally posted by Tirez

i have question about maximum records that in SQL Server can be load? or there are not limitation for that, so it can be run normally because in MS Access there is.

you mean max records that can be held in sql table?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2011-12-22 : 02:36:24

Read about Maximum capacity specifications in sql server help file

Madhivanan

Failing to plan is Planning to fail

Tirez
Starting Member

13 Posts

Posted - 2011-12-22 : 21:08:42

i think you all don't get my point yet. In MS Access there's limitation of maximum records and it can be solved with split the table so it's can be run normally but if it does not it'll be run so slowly. So my question is In SQL server database is there limitation maximum records of it can be held? so it can be run normally and fast even though so many Query table/records and relation ship in it? or the solution is the same with when i'm used to be use MS Access?

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2011-12-22 : 21:26:54

Reference
SQL Server 2000 : http://msdn.microsoft.com/en-us/library/aa933149%28SQL.80%29.aspx
SQL Server 2005 : http://msdn.microsoft.com/en-us/library/ms143432%28SQL.90%29.aspx
SQL Server 2008 : http://msdn.microsoft.com/en-us/library/ms143432.aspx

quote:

Rows per table : Limited by available storage

KH
[spoiler]Time is always against us[/spoiler]

Tirez
Starting Member

13 Posts

Posted - 2011-12-22 : 21:57:18

thanks a lot

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources