This may be a start

SELECT object_schema_name(object_id) As ObjSchema, object_name(object_id) As ObjName, replace (T.definition, 'WITH SCHEMABINDING', '/*WITH SCHEMABINDING*/') as NewDefinition
FROM sys.sql_modules T
where is_schema_bound = 1
order by ObjSchema, ObjName

TEST...

For AD-groups, it no default is used.(as an ad-account may have access through multiple ad-groups)

For SQLusers, the engine sets it to "dbo" by default.

I have noticed this works ! (...

First problem:

This cte will return all rows of county.reporting.dbo.2022 whenever there are results in cte1 ! ( no where clause in exists query )

Same for the second union part

deduplicated by...

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

"Like" does not work with...

Performance has a cost.

That cost starts with declaring the correct data type for columns !

If that is the only  task in your ssis package,  why not use Powershell ?

Dbatools

Export-DbaDbTableData

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, 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.