You can use this script to truncate tables: When you want to clean all tables in a database/schema but keep the design and not recreate the objects During the initial testing period or early stages of a database design
The following script will help you to get all the columns with different collation than the one specified as default for a database.
Getting a list of current backup and restore processes running on your system comes in handy when a lot of people are working on the same environment (and work can overlap) or when you have many automatic backup tasks and want to see which ones are currently running and the time to completion. Don’t be Read More
You can easily find yourself in the need to know the tables with no existing rows from a database, especially in data warehousing scenarios.
In some situations when you are creating a linked server you will want a name for the object that is different from the machine name.