Viewing 15 posts - 1 through 15 (of 25 total)
thanks a lot. very helpful
December 30, 2019 at 11:48 pm
hello guys hope you are all well. if try to schedule through the SQL Agent the following powershell
where the refreshDatabase.ps1 is actually executing one...
July 20, 2018 at 8:55 am
guys dev is a play ground. uat and live are untouchable
June 18, 2014 at 12:25 am
June 17, 2014 at 10:40 am
thanks a lot.
June 17, 2014 at 6:07 am
thanks to all. it make sense.
so is this behavior the same even if i do a DELETE FROM with no WHERE?
June 17, 2014 at 5:42 am
oh yeh CTE, did not think about it. Thanks is pretty much what i need. Thanks a lot
October 1, 2013 at 6:30 am
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...
September 30, 2013 at 6:35 pm
anyone? pct or running_pct?
September 19, 2013 at 8:34 am
is the duration in milliseconds?. very interesting article!! bravo!
November 12, 2012 at 3:09 am
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
July 31, 2012 at 4:28 am
July 30, 2012 at 8:46 am
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.
July 30, 2012 at 4:04 am
Yes got EE on both but i want to use compression only on the subscriber. Is that possible?
July 29, 2012 at 6:39 am
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...
February 4, 2010 at 5:50 pm