I realize this thread is 2 years old, but I figured I'd finish the item and describe the work around instead of leaving the thread dangling since it shows up...

High Availability would ensure there is minimal downtime if for whatever reason (planned or unplanned) the primary server or resource is unavailable.

Disaster Recovery would ensure there is a...

One thing you can do to help, is in the RAISERROR command, there is a STATE parameter that you can set to mark which one of your updates is creating...

It is a known limitation of the DMVs that they only remember the most recent command executed by a session.  If you really need to know what command is blocking...

If the log file is still actively growing, you may be able to figure out what is causing it to actively grow by looking at the default trace.  Here's a...

The first thing I'd suggest for future rerunnability is to break down the work that needs to be accomplished into steps such that each step could be rerunnable and be...

In each database, for each user you can assign them a default schema:
https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-user-transact-sql?view=sql-server-2017
however, if there is the potential for the same table or view name to...

In addition to Lowell's query showing you the details of messages that have errored, there is also a query you can run to see items that are stuck in an...

The way this query is written is using what's called a correlated subquery, in which each row of table Employees will cause an execution of the subquery.  Is the Job_ID...

I think you will also need a GROUP BY clause in your query.  To handle the conditional count, the easiest way is to use SUM instead:
COUNT(L.SCHED_SALE_DT) AS OFFERED,
SUM(CASE...

Note, this is a 5 year old thread.  To help troubleshoot why a transaction log file is growing, you might be able to use the default trace using a query...

For displaying dates, or setting a date column or variable from a string literal, I've always preferred YYYY-MM-DD format.  It's unambiguous and sorts nicely.  I believe the format with DD-MON-YYYY...