Yes, that's right.  That applies to database-level permissions.  If there are any server-level permissions (and let's hope there aren't), you'll need to script those out and add them on the...

Mmmm... non-techies taking technical decisions?  Time to move on to somewhere where you get a bit more autonomy!

I think you're going to need to bite the bullet and log in...

It depends how much data is in the databases.  If I had allowed 29GB max server memory, and I had a 29GB database, I'd be perfectly happy for all the...

All you need to do in the database is associate the user with the login.  The permissions come over with the database so you don't need to touch them.  From...

29GB out of 32 is about 90%, so what's the problem with it using 70%?  SQL Server will grab as much memory as you give it and won't usually give...

• This reply was modified 5 years, 10 months ago by John Mitchell-245523. Reason: Added question mark

Why does it need to be improved - does it not work?

I would start by making sure you have the same number of ENDs as BEGINs.  Then I would consider...

https://docs.microsoft.com/en-us/sql/t-sql/statements/collations?view=sql-server-ver15#examples

John

You'll need to change the collation of the databases or of the server (not a trivial task), or insert COLLATE clauses in your code.  You'll probably find you need a...

Yes, I agree, Phil.  Casting to date preserves sargability; converting to varchar doesn't.

John

Well, if those logins have a default database that doesn't exist, or if you are specifying a non-existent database at connect time, then the connections will fail.

John

It tells you how to evaluate the SET options in the documentation for dm_exec_plan_attributes.  You can use the bitwise operators to do it programmatically.

I don't know whether there's anything...

In which case there must be multiple rows in Base_Risks with the same [pol_numpol contract_id] and [sor_ident contract_update_id] for the value for which you're getting the duplicates.

John

Without seeing your data, it's very difficult to help you.  What happens if you run only the query in the echantillon CTE?  Do you get the duplicate then?

John

Temp tables will be created in tempdb regardless of your database context.  Yes, of course creating them takes resource - disk space, processor, memory, IO.  Do you have a link...

I like it!  And you can simplify it further:

    SELECT  batch_Id
         ,  get_customeVal_3 =...