SQL

Sometimes when presenting your query’s value, you end up with NULL values, obviously. The irritating thing about NULL values, especially with NULL Date values, is that when you attempt to

It is relatively simple to establish what has caused a deadlock in one of your database objects. All you need to do is to know how to manipulate the built

The following query shows the last time a full backup was taken on a certain database. select database_name as [Database], a.name [NameOfBackup], user_name as [BackupTakenBy],backup_start_date, backup_finish_date, backup_size as [SizeOfBackup], is_copy_only,has_backup_checksums,

Ever wondered if you could determine how the SQL Statements will be executed? Well, now you can in two ways: Getting this information whilst not running any queries with SET

Sometimes when trying to backup and restore a database from another database SQL Server throws errors saying that the database is in use. To get around this quite frustrating error,

If any of your applications are using date time field as a complete or part of the primary key and table is used to keep the huge volume of entries