What is the best way to save a large array in database?
It depends on where the data is coming from:


If you do not have a .NET application and you do have the data in a text file, then you can use the BCP.exe utility.
If you have a .NET application, then my preference would be to use a Table-Valued Parameter (TVP). I have an example of one (with .NET / C# and T-SQL code) in the following Stack Overflow answer:

How can I insert 10 million records in the shortest time possible?