When working with a database, it’s important to keep track of the size of tables, so that we can identify which tables are taking up the most space and optimize…
sql server
3 Articles
3
A time may come when you will need to alter your database to use a different collation. You can do this by using the following snippet: USE master; GO ALTER DATABASE [DatabaseName] COLLATE…
To get a rough view of how many rows, total, used and unused space each table has, in a sql server database you can run the following query: USE {Database_Name};…
Page 1 of 1