DaniWeb IT Discussion Community

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/index.php)

- VB.NET (http://www.daniweb.com/forums/forum58.html)

- - help me out (http://www.daniweb.com/forums/thread197339.html)

sweetsasthi

Jun 13th, 2009 3:29 am

help me out

Hai,
We are working in a project which handles lots of data.
How many tables can we have in sql server 2000 so that it can be managed efficiently.Is there any rule for separating the tables.
We store information like candidate details,interview process....
Thanking in advance

sonia sardana

Jun 13th, 2009 4:54 am

Re: help me out

I dnt knw about exact limit but u can craete upto 50,000 tables...& i think so its more than enough...........What u mean by separating tables???? U mean primary table & foreign key table?

sweetsasthi

Jun 13th, 2009 5:53 am

Re: help me out

Thank you so much.The fields i need in my database are

name,permanent and temprory address,phone-cell and landline,state of origin,nationality,experience(post,responsibility,salary,reason fo leaving),name and working status of family members,hobbies,qualification details,Pf,housing allowance.

should i create table for these fields based on normalisation.can you sugest a way to form sql tables with these fields for easy retrival.

adatapost

Jun 13th, 2009 6:32 am

Re: help me out

sonia sardana>I dnt knw about exact limit but u can craete upto 50,000 tables...& i think so its more than enough...........What u mean by separating tables???? U mean primary table & foreign key table?

sweetsasthi>We are working in a project which handles lots of data.
How many tables can we have in sql server 2000 so that it can be managed efficiently.

You have to design tables as per project-definition.

sweetsasthi>Is there any rule for separating the tables.

Here is a link for http://www.datamodel.org/NormalizationRules.html
and
http://databases.about.com/od/specif...malization.htm

sweetsasthi

Jul 4th, 2009 11:18 am

Re: help me out

Thank you.Now I understood more about normalization.

babbu

Jul 5th, 2009 6:46 am

Re: help me out

u can hav as many tables as u want.
regarding ur 2nd question.
each table should be used to store specific information.
so u create separate tables for the various type of info u want.

Teme64

Jul 5th, 2009 7:03 am

Re: help me out

babbu > u can hav as many tables as u want.
When you deal with computers you deal with restricted resources. See Maximum Capacity Specifications for SQL Server 2000. It says:

Quote:

Database objects include all tables, views, stored procedures, extended stored procedures, triggers, rules, defaults, and constraints. The sum of the number of all these objects in a database cannot exceed 2,147,483,647

which is not "as many as you want" ;)

All times are GMT -4. The time now is 5:57 am.