i am talking about the FG which is on another hard-disk.

an i wantto know what can i do if that Hard-disk crash's

how can i still work with the Primary one?

the table contains AccountManagerId & email's,

which i want to pass to the "OLE DB Source"

which in the "Data Flow Task"

i dont think that the sql server should do this kind of work.

although it's good to know, but there are better way's & tools to do it.

try to make 1 million password,

i remember i used some script in the passed, which got my server memory to critical state

when i first looked at the title articles, i was sure it talkes about queues, that work in FIFO - first in -> first out.

but when i saw the row...

as i undestand, i should change the reasonRef column on Con_RecipientToMessages to an included column?

i will be able to make the change only later.

my current index looks like this:

CREATE NONCLUSTERED INDEX [IX_REASONREF] ON [dbo].[Con_RecipientToMessages]

(

[ReasonRef] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,...

i hope this time it ok

i attached both execution plans, he first is with variables, and the second with numbers.

i went over them and didnt see any diffrence?!?

how do i check the last statistics update?

i will add the execution plan later beacuse i am in the middle of the task

but just to update you : when adding the OPTION (RECOMPILE); -> it made...

i added the index and it improved the query time,

i have 2 questions :

1)when i added an index - can i check how long it will take or approximatly how...

i will check it,

but what can i do with the query where i use a variable?

i used the Exists and it seems to help,

the problem is that i split the compare into bulk of 1 million rows each times(which take 1.18 min), but when i...

this is how the table will look: (the total value will be add to the column with the date)

20100101000000,20100301000000,.......,R1

130,0,,,..., ...

i want to build a table which based on the StartDate, where i will have

StartDate(1),StartDate(2).........,R1,total

and this table at the end i will wriite to a file.