Recommended Maximum Number of Tuples in SQL Server Table.
-
Kindly Let Me know the maximum Value which is recommended for the rows in a particular table. Some of my tables have more than 60 lakhs rows.. Kindly Suggest?????????? Thanks in Advance...
-
Kindly Let Me know the maximum Value which is recommended for the rows in a particular table. Some of my tables have more than 60 lakhs rows.. Kindly Suggest?????????? Thanks in Advance...
There is no real limit, it is all dependant on disk space and hardware performance. You may want to look at partitioned tables for performance. Also when you get to these volumes of data indexing is crucial.
Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP
-
Kindly Let Me know the maximum Value which is recommended for the rows in a particular table. Some of my tables have more than 60 lakhs rows.. Kindly Suggest?????????? Thanks in Advance...
As many as you need, and no more.
-
Kindly Let Me know the maximum Value which is recommended for the rows in a particular table. Some of my tables have more than 60 lakhs rows.. Kindly Suggest?????????? Thanks in Advance...