Viewing 15 posts - 211 through 225 (of 1,790 total)
Um - but now the event is full. I'm sure there will be plenty that will come to see the session. Hopefully you can blog about it for us less...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 22, 2011 at 2:48 pm
You're welcome. One consideration which may not be valid but if you have two entries with null end_date's that previous will not work. The following will (included data that I...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 22, 2011 at 2:45 pm
Just a quick warning but I have had those portable drives crash a server before so, test on a non-production box to see how it responds to connecting that up....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 22, 2011 at 2:33 pm
This should get you close;
selectb.Badge,
b.Site,
b.Extension,
b.start_date
fromBadgeSiteExtension a inner join BadgeSiteExtension b
ona.Badge = b.Badge
and a.Site = b.Site
and a.Extension = b.Extension
and b.start_date > a.start_date
and b.start_date < a.end_date
So, yes a...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 22, 2011 at 2:30 pm
jasona22 (3/22/2011)
I do not know nor really understand SSIS. I can't even spell SSIS <-- note red squiggly
As for manually writing transfer TSQL (or SSIS), that is...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 22, 2011 at 12:26 pm
jasona22 (3/22/2011)
As an example, I have 10 databases that have no network connectivity in remote areas of the world. ...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 22, 2011 at 12:09 pm
jasona22 (3/22/2011)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 22, 2011 at 11:27 am
Might be good to attach the plan so that it can be reviewed. Thanks.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 22, 2011 at 9:52 am
Thanks Ninja. I'll be certain to share.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 22, 2011 at 8:21 am
Ninja's_RGR'us (3/22/2011)
GilaMonster (3/22/2011)
Ninja's_RGR'us (3/22/2011)
GilaMonster (3/22/2011)
Not one of Michelle's. There are others that do, do not have links handy.
Alright, I was wondering if you have taken that task on and had...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 22, 2011 at 8:14 am
Glad that worked for you. 😀
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 21, 2011 at 8:01 pm
GilaMonster (3/21/2011)
I'm looking for a couple (and I do mean 2) editors for a non-SSC piece on page restores. Please...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 21, 2011 at 2:23 pm
SQLkiwi (3/21/2011)
Roy Ernest (3/21/2011)
You are flying all the way to Boston from NZ? Thats a pretty long flight you will be in.. 🙂
About 40 minutes short of 24 hours travelling...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 21, 2011 at 1:40 pm
Glad that worked. Typically I would start looking at the wait stats for the rollback process to ensure that it is actually doing something. Regardless, glad things cleared up.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 21, 2011 at 1:36 pm
Stefan Krzywicki (3/21/2011)
Roy Ernest (3/21/2011)
Have anyone heard of Hampton Inn in Plymouth? If so what do you think?
She is crying when I told her that...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 21, 2011 at 12:52 pm
Viewing 15 posts - 211 through 225 (of 1,790 total)