Backup MSSQL database with compression

To create a full backup of MS SQL Server database with compression use this SQL command:

According to database size and your server capabilities, backup time can vary.


Concatenating NULL value columns in T-SQL

Figure 2. Concatenating after changing CONCAT_NULL_YIELDS_NULL to OFF

Concatenating of string columns is not very simple task in T-SQL if you don’t know ANSI standart of it. According to ANSI standart of SQL, concatenating of NULL-value is NULL in the result. It’s not clearly for developer, but it is so.

Let’s see some features for work with concatenating NULL-value columns. For example, I will use tutorial database Northwind and its table Customers. (read more...) Notes of web-specialist
Since 2009