Hi all.
I want to store about 300 crore records into sql server. Is it possible?
Whats the actual memory capacity of sql server for storing records..?
How many max amount of records can I able to store?
Plz let me know immediately
Thanx
6 1251 iburyak 1,017
Recognized Expert Top Contributor
The size is limited only by capability of your computer.
300 records is nothing for SQL server it equipped to process millions of records with no problem in seconds.
Hope I answered your question.
Ya fine...
But I asked for more than crores of records.
Can i store more than 300 crores of records if my computer has enough memory???
Will any memory or cyclic redundancy problem occur?]
Thank you...
iburyak 1,017
Recognized Expert Top Contributor
For exact numbers read this:
http://msdn2.microsoft .com/en-us/library/aa933149(SQL.80 ).aspx
or
http://www.sqlserverce ntral.com/columnists/sjones/maximumcapacity specificationsi nsqlserver2005. asp
Depend on server you have.
I already gone through those links. In those links its mentioned all about the capacity of tables, procedures, datatypes etc., but I want exact size of inserting records or size of a table according to number of records..
Thanx for your replies
iburyak 1,017
Recognized Expert Top Contributor
I already gone through those links. In those links its mentioned all about the capacity of tables, procedures, datatypes etc., but I want exact size of inserting records or size of a table according to number of records..
Thanx for your replies
This is what it says in those links isn't it what you wanted to find?
[PHP]Rows per table Limited by available storage [/PHP]
I assume by number of records it is a datacenter and according to these links you need up to 32 CPU to process such large sized data.
Good Luck.
Oh.. Thanx 4 ur informations..
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: jeff brubaker |
last post by:
Hello,
Currently we have a database, and it is our desire for it to be able
to store millions of records. The data in the table can be divided up
by client, and it stores nothing but about 7 integers.
| table |
| id | clientId | int1 | int2 | int 3 | ... |
Right now, our benchmarks indicate a drastic increase in performance
if we divide the data into different tables. For example,...
|
by: hamvil79 |
last post by:
I'm implementig a java web application using MySQL as database.
The main function of the application is basically to redistribuite
documents. Those documents (PDF, DOC with an average size around 2Mb)
are stored in BLOB column.
The amount of documents for the first year should not exceed 5/6 Giga,
but I cannot make prevision for the next years.
Those documents are mainly just accessed (update and delete are not so
|
by: Kieran Benton |
last post by:
Hi,
I have quite a lot of metadata in a WinForms app that I'm currently storing
within a hashtable, which is fine as long as I know the unique ID of the
track (Im storing info on media files). Up until now I've been sending the
track info to a seperate server app using serialization/sockets which stores
the metadata in a mysql db so that I can query on Artist/Album etc as well.
However, I'm looking to remove the server and move into a more...
|
by: Brad |
last post by:
I have written some code to manipulate data/records in a MASTER (order
header) and DETAIL (order details) tables.
What I have written is too extensive to post but essentially trying to:
1. Assign to a datarow (dr1) the first record of the MASTER table
2. Assign to another datarow (dr2) the second record of the MASTER table
3. If dr1.field1 = dr2.field1, then proceed, otherwise do stop
4. Assign to a third datarow (dr3) the first record...
|
by: hendry.johan |
last post by:
Hi,
I'm currently developing an HR system which involves storing a lot of
configurations per module, such as payroll module, absence/shift
module, training module, etc. total: around 100 configuration items.
Configurations here, ranging from a simple key to value pair, a key to
multiple values, and a key to several records of a / multiple values.
Let me give an example to clarify this:
| |
by: ArmsTom |
last post by:
I was using structures to store information read from a file. That was
working fine for me, but then I read that anything stored in a
structure is added to the stack and not the heap. So, I made a class
that stores the same information.
The user selects any number of records from the file when the program
loads & can then make changes. The records the user selects are added
to an array and changes are made to the records in that array...
|
by: webcm123 |
last post by:
I'm looking for a good method of securing ratings. Cookies lock isn't
sufficient. In addition to cookies I would need something else. I'm
introducing some ways.
-= Storing rates inside seperate tables =-
Seperate tables (artrates, filerates, imgrates) will contain:
ID of item | rate | user | IP
1 rate = 1 record. Field USER will filled if only registered users can
|
by: Lint Radley |
last post by:
Hi Everyone,
I need an opinion here on storing data for a program I am working on the
processes DICOM images. Essentially, my program stores 25-45 (it varies
depending on the user) ranges of pixel values to search the image for.
Currently, I am using a .MDF database that requires SQL Express to be
installed. For only 25-45 records it seems like overkill to me. That
being said, I love the ability to easily update records, delete, add,...
|
by: RobertTheProgrammer |
last post by:
Hi folks,
Although I'm an experienced programmer, I'm new to ASP and relatively new to web programming, so I hope you'll be patient with my questions.
I'm working on a project using ASP.NET and C# for the server side code. I've written code to retrieve data from a database and put it into a dynamic html table for the user to view and edit. Works great. Now I want to save those changes and that's where I'm unsure how best to proceed.
...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| |
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |