Cool findings ....

Its hard to debug and see where exactly the issue is .But one quick solution is

step 1 : delete the destination component

step 2 : Recreate the same component

Step...

My jobs was running perfectly from last 3 months. But suddenly from yesterday my jobs started throwing warning message

Error Message :: ...........................0.4000.0 for 64-bit Copyright (C) Microsoft...

Hi ,

Good article to check

http://technet.microsoft.com/en-us/library/ms178069(v=sql.105).aspx

Interesting :).

I am not sure about your applcation requirement ,but you can use HADOOP to process huge data.

why Doug is not in the list.

Yes both will have same output . But execuation plan will differ.

Thanks for Good observation/question 😎

I guessed the wrong answer as the proc1 is using proc2, While as Proc2 not exist . So Ideally it should throw warning as well as error message.

Good question/explanation Demonfox .

@mit

Nice question to check the attentiveness

as well as to expalin the default behaviour of Varchar data type 😎

I don't think the answer is correct for the question (mentioed in screen shot).Because if you write like this , it will create

a key that is treated...

Hi,

There is no way to do it in one select query directly from table .But a few work around is there

SELECT

...

Hi

Yesterday ,I received the same message like

"There are uncommitted transactions. Do you wish to commit these transactions before closing the window?"

and fully surprised that why it is coming .

While...