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

Size of table

  
   Database Help (Home) -> Client RSS
Next:  Point in time recovery  
Author Message
Husam

External


Since: Jan 28, 2008
Posts: 1



(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: Jan 10, 2008
Posts: 552



(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" <Husam.TakeThisOut@discussions.microsoft.com> wrote in message
news:C00FD3EF-7455-4D70-953B-C83A7D72E647@microsoft.com...
> 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: 1



(Msg. 3) Posted: Mon Feb 25, 2008 6:37 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" <Husam RemoveThis @discussions.microsoft.com> wrote in message
news:C00FD3EF-7455-4D70-953B-C83A7D72E647@microsoft.com...
> 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: Jan 10, 2008
Posts: 190



(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" <Husam RemoveThis @discussions.microsoft.com> wrote in message
news:C00FD3EF-7455-4D70-953B-C83A7D72E647@microsoft.com...
> 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:
Opening table in SQL Server 2005? - This ought to be easy. But I can't figure out how to do it. Using Enterprise Manager in SQL Server 2000, I point to a table, select it, right click and choose Open Table-> Return all rows. Now I have the table open and I can edit to my heart's..

OLEDB: Prepared cmd with NULL input param for NOT NULL INT.. - Provider: SQLOLEDB Version: SQL Server 2000 8.00.760 Script for creating table: CREATE TABLE [dbo].[ADRVERTRETER] ( <font color=purple> ; [ROWID] [timestamp] NULL ,</font> <font color=purple> ; [ROWVERTRETER] [int] NO...

[MS Design Tools] - Class not registered.&quot; - On a Windows 2000 pro workstation I am using SQL 2000 enterprise manager I am trying to return all rows, I get the error message "An unexpected error happened during this operation. [MS Design Tools] - Class not registered." I have reinstall...

Need help choosing front end for SQL Server - I've been working on an Access 97 database that's pretty much reached it's limit in terms of performance and reliability. Although it supports relatively few users (5-10 concurrent) it contains a lot of data (around 30 tables, some with several million..

SQL server tables read-only to ADP - I have successfully migrated an Access 2003 database to SQL server - at least all the tables and queries that resolve into views migrated successfully. I also sucessfully migrated all my forms and code into an ADP project. Everything works with one..
   Database Help (Home) -> Client All times are: Pacific Time (US & Canada) (change)
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 ]