Log-shipping Queries

First check the last file copied and restored to the secondary. Run the following queries on the secondary node. The following query…

Read More

T-SQL for identifying slow-running queries on a database

Views – 1446

Read More

T-SQL to check the properties of all the databases on a server

Views – 1873

Read More

Configure Email Alerts via T-SQL

You can run the following SQL script to ensure email alerts are configured for the LSCopy and LSRestore jobs:

Views – 2054

Read More

Using the LIKE keyword more efficiently

from Pinal Dave’s article here: http://blog.sqlauthority.com/

The previous query does find FirstName values beginning with the letters ‘A’ thru ‘K’. However, when…

Read More