Viewing 15 posts - 4,231 through 4,245 (of 9,722 total)
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
Giving a W.A.G. because it's been a long time since I learned my AD security... SQL Server is acting with your user credentials in SSMS rather than the service account...
July 5, 2012 at 12:34 pm
bcsims 90437 (7/5/2012)
SQLRNNR (7/5/2012)
crookj (7/5/2012)
Ray K (7/5/2012)
(For the benefit of those outside the USA, that was...
July 5, 2012 at 12:10 pm
Can you add the account via the SSMS GUI? Or does it error out when you hit "OK"?
July 5, 2012 at 11:40 am
Please post CREATE TABLE statements for your tables in the query. Please post INSERT statements with multiple rows of sample data for us to run the query against.
July 5, 2012 at 11:39 am
Viewing 15 posts - 4,231 through 4,245 (of 9,722 total)