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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-10-24 : 09:23:29
|
| Shailesh writes "Dear Sir/Madam,I just want to know, whether MS-SQL server 7.0 is capable enough to handle this much amount of records. If you feel that MS-SQL 7.0 is not capable then will you kindly suggest me the best alternative for RDBMS.For your information i am giving you the present configuration of server on which MS-SQL Server 7.0 is installed -* PIII 500Mhz (Intel Based)* 512MB of RAM* 8GB of Hard-Disk space.* WinNT server 4.0 with Service pack 6In one of the Table :- Number of Records:- 3.2 Lacs.Record Size:- 0.22KB.Size:- 72MB.Structure:- [Record_Id] [int] IDENTITY (1, 1) NOT NULL ,[Client_Id] [varchar] (24) NULL ,[Contact_Number] [int] NULL ,[Type_Id] [int] NULL ,[Code_Id] [int] NULL ,[Last_Code_Id] [int] NULL ,[Date] [datetime] NULL ,[Numeric] [float] NULL ,[Alphanumeric] [varchar] (120) NULL ,[Creator_Id] [varchar] (12) NULL ,[Create_Date] [datetime] NULL ,[mmddDate] [varchar] (4) NULL Regards,Shailesh M" |
|
|
|
|
|
|
|
Doubt ( Is the MSSQL server 7.0 is able to handle 3.2 lacs of records?)