Viewing 15 posts - 5,146 through 5,160 (of 9,712 total)
You didn't post your index(es). What are they?
November 4, 2011 at 7:14 am
bubs (11/2/2011)
-"For the delete, make MasterReviewID on PeerReview reference MasterReview with a cascading delete."Can you please provide an example?
Look up Triggers in SQL Books Online. That's what he means.
-"But for...
November 4, 2011 at 7:12 am
WHOOT! Just got my author's copy of Space Tramps in.
Space Tramps information:
Amazon link: http://www.amazon.com/Space-Tramps-Full-Throttle-Tales/dp/0984592741
ISBN numbers, if you care to order it from your local bookstore (which I highly encourage!):
ISBN-10: 0984592741...
November 4, 2011 at 6:39 am
Evil Kraig F (11/3/2011)
I should learn not to post when I'm typing quickly.
Or when you have the lint ball monster from H3CK watching over your shoulder with it's evil googly...
November 4, 2011 at 6:35 am
Lynn Pettis (11/3/2011)
November 4, 2011 at 6:32 am
jcrawf02 (11/3/2011)
November 3, 2011 at 1:03 pm
I forgot to mention something.
If push comes to shove and you can't use an Execute SQL Task, and absolutely must have a Data Flow Task instead, use a stored procedure...
November 3, 2011 at 12:22 pm
Stefan Krzywicki (11/3/2011)
Brandie Tarvin (11/3/2011)
ricer (11/3/2011)
Is the GUID your clustered index key as well?If so you are probably seeing lots of page splits when you are doing inserts.
I fail to...
November 3, 2011 at 12:19 pm
Jack Corbett (11/3/2011)
I've never used the multi-cast, I'll have to look at it as it might be a better way to handle this.
Multicast is a funderful thing. Try it. You...
November 3, 2011 at 12:12 pm
ricer (11/3/2011)
Is the GUID your clustered index key as well?If so you are probably seeing lots of page splits when you are doing inserts.
I fail to see how having a...
November 3, 2011 at 12:09 pm
Quick question. Has anyone else been approached by John Millward of Callidus Technology Limited for permission to use your SQL Articles on a social networking site he's putting together?
The site...
November 3, 2011 at 12:02 pm
Stefan Krzywicki (11/3/2011)
Brandie Tarvin (11/3/2011)
November 3, 2011 at 11:56 am
For the two instances you don't require any transformations, don't use the Data Flow task. Using a stored procedure in an Execute SQL Task is much faster.
BTW, what type of...
November 3, 2011 at 11:36 am
Jeff Moden (10/5/2011)
...
The answer the interviewee returned was "I don't know... we always used the GUI...
November 3, 2011 at 11:32 am
Sean Lange (10/3/2011)
November 3, 2011 at 11:24 am
Viewing 15 posts - 5,146 through 5,160 (of 9,712 total)