thanks a lot. very helpful

hello guys hope you are all well. if try to schedule through the SQL Agent the following powershell

SL 'D:\DBA'
.\refreshDatabase.ps1

where the refreshDatabase.ps1 is actually executing one...

guys dev is a play ground. uat and live are untouchable

dev environment

thanks a lot.

thanks to all. it make sense.

so is this behavior the same even if i do a DELETE FROM with no WHERE?

oh yeh CTE, did not think about it. Thanks is pretty much what i need. Thanks a lot

OK, thanks.

I came up with this, coming from my MDW database. is there any other more efficent day to do it?

when posting here i loose the formatting sorry. how...

anyone? pct or running_pct?

is the duration in milliseconds?. very interesting article!! bravo!

My company as a policy does not allow to build extra databases. So for me i built a CMS instance and use powershell to manage my instances

Exactly.

What i would like to do is to copy the database on the subscriber. I will copy just tge structure with no data.

Enable compression on the tables i want.

And...

Yes got EE on both but i want to use compression only on the subscriber. Is that possible?

what about SSIS?

can you have SSIS on server A and DB services on server B?

SSIS packages will be installed on the filesystem of server A.

Server B will have jobs setup...