With SQL Server 2014 Microsoft changed the way they do Cardinality Estimation and with a trace flag allowed the use of the previous Cardinality estimator, this would explain the differences...

If it is running is likely isn't waiting on anything it is executing the task that it needs to do.  You should only see a wait if the query isn't...

You can add teh Lock_acquired event to your trace, but that is going to be A TON of information because everything (unless using snapshot isolation) takes some kind of lock. ...

TABLOCK is an option on BULK INSERT so find out if they are using that option, if they are actually using the BULK INSERT statement.  The other reason that they...

Encrypting a backup shouldn't impact memory at all as the same pages will need to be read into memory, there will be small hit in CPU use, probably < 5%,...

Lynn is correct.  Those columns in msdb.dbo.backupset indicate if the backup itself was run with the Encryption option, not that the backup is of a database encrypted with...

Do you mean the server level "remote access" setting or the "allow remote connections" setting for the service?  "allow remote connections" has to be on in order for you to...

If I understand correctly I think this will work:

update status_table
     SET Status = CASE OPEN_CLOSE
                ...

Brandie,

Take a deep breath, this won't be as hard as you think.  If you are using SSIS and a data flow task to move the data, you'll just...

Great glad I could help and thanks for letting me know that it helped you out.

This is an even simpler option:

WITH VTE AS
  (
   SELECT
    *
   FROM
    (
      VALUES (3),
        (25.75),
        ...

If you have your databases in an SSDT database Project you can use T4 templates to generate CRUD procedures.  I've also used written T-SQL to generate them, but since I...