I don't suppose removing privs from users and forcing them to use a stored procedure to do restores is an option?

The "best" way would be to have an "INSTEAD OF" trigger that checks the entry.  You could also do it after the fact with a normal "after" trigger that would...

What are you saying you want done if an attempted entry contains one of the taboo characters?  Do you want to silently reject the entire entry or just remove the...

I avoid SSIS like the plague and so I'm not sure but it looks to me like SSIS isn't able to access the file.  Have you checked to make sure...

Please read the second paragraph from the article at the following URL for the answer to that...

https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-internal-tables-transact-sql?view=sql-server-ver15

If you stop and think about it, all the supposed light-weight things you propose are just another way of capturing history except they are more heavy weight.

The other part about the documentation on index maintenance is that it's spread all over hell's little half acre.  This IS a spot that actually describes what REORGANIZE does in...

Thoughts this crew might like this:

"Do not assume...

  I can say that some indexes rebuild from a 98% frag.....  rebuild will take it down to less than 1%, give it an hour and that save index...

You can get it from the following SQL Friday link, Lynn.

https://sqlfriday.net/past-sql-friday-sessions/sql-friday-17-jeff-moden-on-the-secret-to-high-performance-code-high-performance-test-data/

For those recommending modifying the code - this is 3rd party vendor code and modifying that code without the vendors permission could invalidate the contract.  Some vendors will...

The new CE thing killed us.  We had to turn it off.

With that in mind, Adaptive Joins has me scared to death.

I won't get into the other stuff on that...

So would you recommend to run update statistics with full scan for the whole database weekly instead of normal update statistics? One thing I noticed when I compared...

I normally don't do self-advertisement but I'm giving a presentation tonight at 6PM EDST online on an interesting subject.  Here's...

K.  Thanks.  One of your answers begs another question.  Is that "other" database on the same instance?