New answers tagged storage
Create a new table Table_A_Archive with exactly the same schema as Table_A_Changes. Partition both these tables by, say, one-month date ranges. As data becomes stale in Table_A_Changes swap that partition out and swap it into Table_A_Archive. Your data retention policy can be efficiently enforced this way, too. A view which unions the two tables can make ...
There is nothing that allows SQL Server to modify the initial size of a file automatically, by itself. The file must have been altered by a sysadmin or someone with ownership of the database. I expect they were setting the max size of the file and set the wrong option.
Top 50 recent answers are included