Sorting values in a MySQL database is a very common task when you have to deal with data. However, when it comes to sorting data that include null values, there…
db
4 Articles
4
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…
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