Viewing 15 posts - 4,231 through 4,245 (of 9,726 total)
I've never run into an instance where using CAST over CONVERT (or vice versa) has made a difference in code performance. The problem is usually related to the rest of...
July 6, 2012 at 10:49 am
OCTom (7/6/2012)
Brandie Tarvin (7/6/2012)
July 6, 2012 at 6:36 am
Another recommendation:
Learn the data, learn the business.
If you know the data well enough to recognize bad data the instant you see it on a report or in an administrative request,...
July 6, 2012 at 6:24 am
One thing I strongly advise: Do not take this career path just for the possibility of high pay. If you do not like what you are doing, then the pay...
July 6, 2012 at 6:19 am
Before removing any indexes from a production system, it is a wise idea to try removing them from a QA environment and running full-load tests to see if it in...
July 6, 2012 at 6:16 am
You cannot use the keyword IN on the "result" side of a CASE statement, only on the conditional side of the statement.
CASE means "please check"
WHEN means "these conditions"
THEN means "this...
July 6, 2012 at 6:09 am
So you see more clearly what I'm working with, I've attached a snapshot of my SSIS package with a few sensitive things blurred out.
The job runs and sends one to...
July 6, 2012 at 5:58 am
Brandie Tarvin (7/6/2012)
Koen Verbeeck (6/8/2012)
Enable logging on preexecute on postexecute events, so you can exactly see what is going on.I think I shall do just that. Thanks, Koen.
Hmm. Except it...
July 6, 2012 at 5:48 am
Koen Verbeeck (6/8/2012)
Enable logging on preexecute on postexecute events, so you can exactly see what is going on.
I think I shall do just that. Thanks, Koen.
July 6, 2012 at 5:40 am
andersg98 (6/7/2012)
Is the entire dataflow configured inside a Sequence container?
No. It's configured in the ForEach container.
July 6, 2012 at 5:40 am
Hey, guys. I'm going to post something and if it's inappropriate, please let me know.
A lot of people have been displaced due to the recent East Coast flooding and the...
July 6, 2012 at 4:36 am
Someone please explain to me why donut shops insist on placing single donuts in the bag icing side down. I don't want my icing sticking to the bottom of the...
July 6, 2012 at 4:30 am
Michael Valentine Jones (7/5/2012)
Brandie Tarvin (7/5/2012)
Michael Valentine Jones (7/5/2012)
July 6, 2012 at 4:28 am
Douglas Osborne-229812 (7/5/2012)
Brandie,Do you have a short example?
Not knowing which of my three suggestions you want an example for, I'll give you the trigger:
--Table is the user table you're logging....
July 6, 2012 at 4:22 am
Viewing 15 posts - 4,231 through 4,245 (of 9,726 total)