Viewing 15 posts - 7,261 through 7,275 (of 18,923 total)
Login with windows admin account and simply change the password of sa.
January 21, 2011 at 11:12 am
My apologies, I didn't mean to be a jerk. I intented to give a strong vote to not do something so huge with cursors, which are much slower most...
January 21, 2011 at 11:07 am
CELKO (1/21/2011)
In Standard SQL there is an optional...
January 21, 2011 at 10:37 am
opc.three (1/21/2011)
January 21, 2011 at 9:55 am
Wow, this discussion is almost as long as the article :hehe:.
Great job Jeff :w00t:.
January 21, 2011 at 9:53 am
Donalith (1/21/2011)
Thank you. I thought of using the "with cte " formula but I'm working with a dataset of over 700 million rows.
Then you'll have to do with Jeff's article...
January 21, 2011 at 9:48 am
BTW you can't have a go statement in the definition of the trigger... the code will stop there.
January 21, 2011 at 7:44 am
DELETE SC FROM SecondaryCategory SC INNER JOIN DELETED D ON SC.[ArtistID] = D.[ArtistID] AND SC.[ArtistGenreID] = D.[ArtistGenreID]
January 21, 2011 at 7:44 am
Ferguson (1/21/2011)
GSquared (1/21/2011)
I have heard two threads in this -- one is "but when will I have time to do both" and...
January 21, 2011 at 7:41 am
Maybe this can give you "our" perspective on money.
"Money isn't everything, but it ranks right up there with Oxygen",
Zig Ziglar.
From my perspective when I read a consulting offer, I...
January 20, 2011 at 5:52 pm
Grant Fritchey (1/20/2011)
No, it was a stupid design.
Potato, Potâto :hehe:.
January 20, 2011 at 11:26 am
Grant Fritchey (1/20/2011)
January 20, 2011 at 10:46 am
Agreed here. There's no way out of this. You either pay for a license or pay for time.
The only question here is how much is the license compared...
January 20, 2011 at 10:45 am
bitbucket-25253 (1/20/2011)
mwk (1/20/2011)
the database, but just want to make room by deleting the older records.
Is...
January 20, 2011 at 9:59 am
Viewing 15 posts - 7,261 through 7,275 (of 18,923 total)