Viewing 15 posts - 5,146 through 5,160 (of 9,722 total)
I will let you argue the point with the man I learned this from, Brian Knight. Talk to him.
November 8, 2011 at 6:11 am
Stefan Krzywicki (11/7/2011)
... The repeated "DISTINCTS" are a little weird...
I've actually run into situations where I need duplicate DISTINCTs because of the way the data comes out of a complicated...
November 7, 2011 at 8:55 am
Koen Verbeeck (11/7/2011)
Stefan Krzywicki (11/7/2011)
But there isn't a 2008 SSIS forum!
No, but there is a general SSIS forum in the Data Warehouse section 🙂
(to be honest, that forum is not...
November 7, 2011 at 8:49 am
jcrawf02 (11/7/2011)
SQLRNNR (11/4/2011)
SQL Kiwi (11/4/2011)
SQLRNNR (11/4/2011)
Cadavre (11/4/2011)
Brandie Tarvin (11/4/2011)
SQL Kiwi (11/4/2011)
So, it dependsSomeone so needs to come up with an interview question where this is the exact answer that's needed.
Isn't...
November 7, 2011 at 7:16 am
Sorry it took me so long to respond. I've been busy.
I appreciate the answers, but I'm not sure you understand what I'm looking for. I want to fiddle with the...
November 7, 2011 at 6:10 am
Sean Lange (11/4/2011)
November 7, 2011 at 5:26 am
Alexander Suprun (11/4/2011)
Stefan Krzywicki (11/3/2011)
Brandie Tarvin (11/3/2011)
If push comes to shove and you can't use an Execute SQL Task, and absolutely must have a Data Flow...
November 7, 2011 at 5:19 am
cliffb (11/4/2011)
In terms of data types, I would not use a FLOAT to define a monetary field. FLOAT is an approximate numeric.
You'd be amazed at how many businesses want...
November 4, 2011 at 11:30 am
SQL Kiwi (11/4/2011)
So, it depends
Someone so needs to come up with an interview question where this is the exact answer that's needed.
@=)
November 4, 2011 at 8:30 am
Ki,
You do remember that Table Variables use TempDB, right?
November 4, 2011 at 7:29 am
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
Viewing 15 posts - 5,146 through 5,160 (of 9,722 total)