One of the database of SQLServer is 444 GB. We would like to split the database to multiple file. What would be the process to split the database?
The best way for us to answer is to first ask you why? What advantage do you intend to gain and why is it an issue when such a database remains in a single file?
I can also tell you that it usually doesn't help performance unless you can guarantee that you have separate sets of physical disks and you've identified those things where such a separation would actually matter. Yep.. it can help a little with contention but fixing the code will do a much better job if you have such contention.
SQL Server 2016 introduced a new built-in table-valued function, STRING_SPLIT that splits the provided input string by a specified separation character and returns the output separated values in the form of table, with a row for each delimited value between each separator character
18 People are following this question.