For the time, I'd so a single DATEADD with only SECONDs being added, something like this:

DECLARE @order_time float
SET @order_time = 11456

SELECT CAST(DATEADD(SECOND,...

Create a nonclustered index using the clustering column(s) as key(s) and INCLUDE the search column.  That's about the best you can do with this type of requirement.

The data and log files for any given db must always be on separate drives.  That is, that a single physical drive failure cannot destroy both data and log files...

Interesting ... do DBAs really use the gui to do backups and restores?  I never have.  For one reason, then I have no accurate record of what was done.

You're welcome.  Glad it helped, because that would be a confusing error indeed.

This may not be the most efficient, but I believe it works, and shouldn't be too much overhead anyway unless you have lots of unqiue Ids:

;WITH...

Try some type of concatenation, like this:

SELECT
Message = NULLIF(STUFF(
      CASE WHEN Name  IS NULL OR Name  = '' THEN ', Name'  ELSE ''...

Make sure you're also looking at the schema name along with the table name.  Maybe the schema is not "dbo" and so it looks like the table's not there when...

As noted, a name, "sd", that follows immediately after a table name, "sys.databases", becomes an alias for that table.  In fact, it becomes the only name for that...

I suggest generating a pattern to identity what the phone string contains.  Then all you need to do is decide which patterns are acceptable and which aren't.

For example,...