Please, clean up the question wording.

It was a little confusing differentiating between the "database" which cannot be paused; and the "database engine" which can be paused. The pause of the...

My mathematics minor finally gets some use 😛

thanks for this one, saves me from using sp_help tablename. The previously fastest way I knew.

Good to know of the function exists but I still find it more useful to subtract, as this function only returns date; not date and time. I program in a...

Depending on the configuration setting of SQL you could have the option of both statements failing.

Unless the reconfigure statement was followed by "with override"

Reconfigure with Override

I have never explored a CTE before. Good new research and learning for me.

I will use the sub select as the new work around until I finish my learning on...

Those snippets are directly extracted from the stored procedure in its before and after state.

Here is the function

if exists (select * from sysobjects where name='fn_GetTargetTimeInServiceHours' and type='FN')

drop...

Basically you are taking the application approach to your SQL instances. Each application, gets a dedicated service account to ensure the application is properly restricted within your environment.

And it not...

SQL2005 and higher have the coalesce command.

declare @remaining_string varchar(max)

set @remaining_string = ''

select @remaining_string = coalesce (@remaining_string + db.name + char(44), '')

from database db (nolock)

where db.id = X

order by db.name

At...