Most common mistake is to put data into a varbinary(max) column data is frequently needed for filtering etc.

IMHO that is not what this data type is intended for. ( with...

I hope your tenants don't have direct ( e.g. SSMS ) access to the database with mixed-tenant information in the objects.

CustomerAcctNo  DECIMAL(9, 2)  ???  1234567.02 ?

GPF   DECIMAL(9, 2)  ?? you expect big tanks ? 9999999.99 GPF

Rebate   DECIMAL(3, 2) ?? don't you expect rabates to potentially be > 9,99

have you tried Select ... from morerecenttable EXCEPT select ... from oldersnapshot

This gives you new and modified rows. Having that set, you can compare with individual columns

don't use dynamic sql in your stored procedures! ( or use only parameterized queries with the semi generated sql )

don't grand datareader/datawriter !! Only grant exec for sprocs it is...

I would say "Yes" as it is a logged and persisted operation.

Easy to check using sys.dm_db_stats_properties for a given statistics.

#Fail !!!

You need to keep all  transaction log...

That is SQLServer backup compression server level setting ( or at backup command level ) !!!

Do not...

This indicates a bug in the marvelous software.

did you upgrade your SQLServer to its latest cumulative update? ( please do ! )

• This reply was modified 2 years, 10 months ago by Johan Bijnens.

it is a bad practice, but that doesn't mean it cannot be done.

Did you try "create table tempdb.dbo.tablename ..."

Please provide Indexes  for the tables to support whatever you want to do !!!

What did you try?

Why not just update what needs to be updated and insert what's new ?...

must be a routing issue.

Check the path ( tracert ) which your connection has to follow to be able to connect to your instance.

- router/switches/vlans/Wirewalls/...

• does it also need that...

Double check if the target backup location hasn't been switched to a (windows) compressed volume !

Have a look at : "clustered-and-nonclustered-indexes-described"

and /  or "Effective Clustered Indexes"