Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Size of table

 
   Database Forums (Home) -> Client RSS
Next:  opening for Sr.Staff Engineer with a research lab..  
Author Message
Husam

External


Since: Jan 28, 2008
Posts: 2



(Msg. 1) Posted: Mon Jan 28, 2008 3:45 am
Post subject: Size of table
Archived from groups: microsoft>public>sqlserver>clients (more info?)

Hi EveryBody:

How much data can be saved in the tabel in the database ?

In another way can the size of table be 100 GB ?

any help will be appreciated

regard's

Husam

 >> Stay informed about: Size of table 
Back to top
Login to vote
Russell Fields

External


Since: Feb 21, 2007
Posts: 457



(Msg. 2) Posted: Mon Jan 28, 2008 12:05 pm
Post subject: Re: Size of table [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Husam,

http://msdn2.microsoft.com/en-us/library/ms143432.aspx -- SQL Server
Capacities

You can make a table 100 GB, if you have the space. Performance issues may
arise, of course, depending on the contents and the access required.

RLF

"Husam" wrote in message

> Hi EveryBody:
>
> How much data can be saved in the tabel in the database ?
>
> In another way can the size of table be 100 GB ?
>
> any help will be appreciated
>
> regard's
>
> Husam
>

 >> Stay informed about: Size of table 
Back to top
Login to vote
Johnny

External


Since: Feb 25, 2008
Posts: 6



(Msg. 3) Posted: Mon Feb 25, 2008 4:01 pm
Post subject: Re: Size of table [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

There's storage space and memory consumption.

Sure the table can be 100 GB, but unless you're running a powerful machine
with a bunch of extra memory and extra fast storage - it's going to perform
horribly.

Cheers,

John
http://www.sisense.com
"Business Intelligence For Everybody!"

"Husam" wrote in message

> Hi EveryBody:
>
> How much data can be saved in the tabel in the database ?
>
> In another way can the size of table be 100 GB ?
>
> any help will be appreciated
>
> regard's
>
> Husam
>
 >> Stay informed about: Size of table 
Back to top
Login to vote
Ekrem_Önsoy

External


Since: Aug 28, 2007
Posts: 179



(Msg. 4) Posted: Wed Mar 05, 2008 11:47 am
Post subject: Re: Size of table [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Note that, in SQL Server 2005 Express Edition, your database can not exceed
4GB of size.

You don't have this limitation for other editions of SQL Server 2005.

For more:
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

--
Ekrem Önsoy



"Husam" wrote in message

> Hi EveryBody:
>
> How much data can be saved in the tabel in the database ?
>
> In another way can the size of table be 100 GB ?
>
> any help will be appreciated
>
> regard's
>
> Husam
>
 >> Stay informed about: Size of table 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Log Size grows rapidly - hi I have implemented merge replication on my machine my question is that my database log size is growing very rapidly. Can any one help me in this regards why the log size grows in GB within 3 to 4 hours. Waiting for reply anxiously Farhan Iqbal

How to tell sql server the maximum size my temptable will .. - How to tell sql server the maximum size my temptable will grow so that it does at most 1 memory allocation?

Why the table is locked ? - Dear all, I have Access Font End to SQL server Back end. In an Access form, I use combobox, based on a stored procedure, which based on 1 table (SELECT LocationID, LocationDescription FROM Locations). When I open the form and check in the SQL server....

Temp table. - Is there any one let me know, in the stored procedure I am creating temprary table and droping table at the end, when single user access it is working fine but when simultaneous user access of that stored procedure it giving error like #Temp table is....

updating an sql table using another sql table - I started with a CSV file which I imported into SQL to create a table. My initial table is employees (ID, LastName, FirstName, Department, Division, Title, OfficePhone, MobilePhone, Login). The new table is called employees_update ( LastName, FirstName,...
   Database Forums (Home) -> Client All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]