|
Do you mean SQL Server or MySQL? They're somewhat similar, but not exact clones. Although your hosting company will have as much to do with the answer as anything else.
There's no total number of rows allowed in a SQL table. This is only limited by the amount of storage you have. I've worked with databases that had hundreds of millions of rows in a single table.
You can shrink a SQL Server database by running the DBCC command, or through Enterprise Manager ( '97 and 2000 ) or SQL Server Management Studio ( 2005 ). When you delete data, it's not really "deleted," it's just marked as empty. Eventually the space will get reclaimed, but the point is that just deleting some records won't change the size of your file. ( Actually it's likely to make the transaction log a tiny bit bigger. )
Again, if you mean the MSFT product, it's very simple to move a database from one server to another. Just detach the database, copy the file to the new server, and attach it. Here's the rub: you can't copy the file while it's under SQL's control ( "attached" ), so you need access to get into a different database ( master ) and detach yours. Then you need access to the mdf/ldf files themselves, which are probably stored in a different folder on your server.
|
