Short but very enjoyable indeed 🙂

A bit of Fulltext history can be found at ref: "Full-text index architecture"

Thank you for the feedback.

( I was out for a week of vacation. )

Just wondering why you add the uniqueidentifier to the physical filename ??

Move N'ftrow_FTC_titles' to N'E:\Program Files\Microsoft SQL...

you need to extract the logical filenames from the backup file!

you need to hard code the full restore statement (or generate the statement in to a variable to be executed...

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, 9 months 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, 9 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