It might come time where you need to alter your database to use a different collation. You can do this using the following snippet: [crayon-58480392872f2119297576/] When you execute the above snippet you may come to the following error: This error occurs when your database in Multi-User mode where users are accessing the database or there are ...

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: [crayon-583450f43d6a5734372322/] Another way is using the stored procedure sp_spaceused which displays the number of rows, disk space reserved, and disk space used by a table, indexed view, or Service Broker ...