You have to investigate what is causing that much tempdb consumption.

• #(#)temptb or @temptb
• regular tables created in tempdb ?
• version store (snapshot isolation level)
• queries performing group by, sorts,...

check sp_refreshview

EXEC sp_refreshview '[View_SCHEMA].[ViewName]'

• This reply was modified 3 years, 1 month ago by Johan Bijnens.

Double check SQLServer "max server memory (MB)" setting has been configured on 64-bit systems ! ( or it will consume nearly all available ram and compete for it !)

Check "

1. You should only use a single "order by" in your query. ( remove the first ' order by 4 desc' )
2. If Union partners each have unique results, use...

Make sure you have added the service account in the security policy to "perform volume maintenance" ! (= activate Instant File Initialisation ) ( needs a restart of the instance...

With most articles, you can pose questions.

As these people have tested the subject, they may already have the answer ready or even blog about it later on.

GRANT view definition TO [uRole_ViewDefinition/useraccount];

• why haven't you launched that question at the individual sites ?

someone must have granted at least read to public ( for the tables ).

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

Thank you for the feedback.

Your assumption is incorrect !

It needs the space, not according to backup size, but according to the size of the files of the original database !

Sequence should be:

1. check available...

Best practice is hat match the SIDS. (or you'll have to fix that with every failover )

Easiest way to do that is do use DBATools (free)  Copy-DbaLogin

You can restore any kind of db as long as you have a FULL backup (and the needed diff/log restore to get it to the PIT you need).

After the restore,...

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

why do you need to convert to char(8) ?

where CONVERT(DATE, CONVERT(CHAR(8),[WED] ))

What's the data type of your column [WED]  ??

Rule number 1 ( with ANY RDBMS ):...

SELECT M.mailitem_id
     , M.profile_id
     , M.recipients
     , M.subject
 --    , M.body
 --...

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