2, SQL Server 2000 will not actually split the table, it does not have this feature.

3, MS SQL Server 2000 and subsequent versions, there is no actual splitting of tables into multiple tables, there is no function to split a database into multiple databases. The latest version of MS SQL now is 2012.

4, to speed up the SQL Server search method is very simple, add the necessary restrictions can be, in the restrictions for the determination of the conditions for the unidirectional growth of the conditions, the search result set (the results of the data is not a lot of articles), the SQL Server will automatically become faster, can be used equal to the conditions, do not use greater than, less than the conditions, as far as possible to avoid fuzzy wildcard conditions. The indexing of commonly used sortable conditions can effectively speed up the system search.

5. More than 300,000 pieces of data per day puts a lot of pressure on SQL Server! Stored procedures, client if not specially optimized in the design process, for the average enterprise hardware equipment, it is more difficult to bear.

6, related knowledge, please Baidu in the "sql server ten million records" to search for other people's words.

In addition, I personally recommend that such a database in the search, to build the library in a yearly manner, the way to build a table in a monthly manner, in the search, such as across the year, across the month, the need for composite searches, it is difficult to design.