CODEWITHSUNDEEP
sqlsql-server-2014
Haminteu
Haminteu

Reputation: 1334

SQL Server database with Large Data

I will have a 29 billion records on each table which is coming from other sources.

There are 12 tables in the database. Each table has 3 columns with datatypes DateTime, varchar(15), and float .

I need an advice for the best solution for this case. Will SQL Server be able to accommodate all these rows?

How can I know the size of database in Gigabyte if SQL is able to accommodate all rows?

Thank you.

Upvotes: 0

Views: 59

Answers (1)

ASP
ASP

Reputation: 666

Size of the table is Limited by available storage for your server. Your data file can be up to 16TB. So you can load your data to SQL Server 2014. Please refer the document : https://msdn.microsoft.com/en-US/library/ms143432%28SQL.120%29.aspx?f=255&MSPPError=-2147217396

Query to check Database size

SELECT DB_NAME(database_id)AS DatabaseName,
Name AS LogicalName,
size*8/1024/1024 Size_in_GB
FROM sys.master_files
WHERE DB_NAME(database_id)='Your DB Name'

Upvotes: 1

Related Questions