DECLARE @CopyUser varchar(30)
DECLARE @Dbnames varchar(8000)
DECLARE @Sql varchar(8000)
DECLARE @UserOp varchar(30)

SET @Dbnames = 'DB1,DB2,DB3' --<<--!!set these values before running!!--<<--
SET @CopyUser = 'User1' --<<--!!set these values before running!!--<<--
SET @UserOp =...

You should never shrink a database, only shrink a file(s).

It seems as if you have one gigantic data file (very bad idea, btw, you should use multiple data files, but...

You must use the max memory setting when you put more than one instance of SQL on a given box, for the reasons others have stated above.

And, for that many...

CONCAT is not a safe way to do this because different values could appear to be the same.

Do all the columns have to match?  Or just some?

For now,...

You shouldn't use 'n/a' as a "value" in place of NULL. Effectively you're corrupting the data. You should just use NULL itself instead.

If all readers of the table...

That is not advisable as this will always start the job, even when it is disabled !

My point is:  When a sysadmin or "sqlagent job manager" disables a job...

I'm almost certain there's a more efficient way to do this, but I can't think of it now.

;WITH cte_valid_first_dose AS (
    SELECT *
 ...

SELECT 
    US.UID, 
    CASE WHEN COUNT(UD.UID) > 0 THEN 'YES' ELSE 'NO' END AS [UID Loaded],
    CASE...

You can start the job easily from the trigger using:

EXEC msdb.dbo.sp_start_job @job_name = '<your_job_name_here>'

That will just start the job and immediately return to the trigger (that is, I'm confirming that...

So just to clarify. if i have a clustered index on say contactid and invoiceid however none of the updates are on those columns then there wouldn't be a...

Are you on the latest CU?  If you are behind any maintenance patch, I'd put that on first before doing other work.

SELECT SUBSTRING(TableName, CHARINDEX('dbo.', TableName), 8000) AS TableName

FROM dbo.whatever

WHERE TableName LIKE '%dbo.%'

WARNING: make sure that no more than, say, 3500 tables or so are processed by this script.  The script is fairly complex and having way too many tables present  (particularly...

If you just want table names that start with 'dbo.', then you can do this:

SELECT STUFF(Tablename, 1, 4, '') AS Tablename
FROM dbo.ListOfTables
WHERE Tablename LIKE 'dbo.%' /*allows an...

You can't ever look at missing index stats in isolation.  You also need to look at existing indexes and their usage stats (and often I/O counts as well).

First, before doing...