The index was recommended by optimizer.

The table itself is having 14 indexes. Earlier it was more then 25, but we removed some indexes that were...

Gail,

I understood that. And I have read the article you mentioned, its really nice.

Actually I meant this feature of...

One more Issue:

Is it going to change in next version?

Kevin, Gail

Thanks a lot.

declare @image1image

declare @text1text

declare @ntext1ntext

declare @varchar2varchar

declare @nvarchar2nvarchar

declare @varbinary2varbinary

declare @varchar1varchar(max)

declare @nvarchar1nvarchar(max)

declare @varbinary1varbinary(max)

First three variable declarations are definitely going to produce an error.

Text, Ntext, and Image data types are invalid for local variables.

With large-value data types You can define variables that can store large amounts of data, up to 2^31-1 bytes of character, binary, and Unicode data. That was not possible using...

No, but you will find many here who are ready to help for free.

I hope you are not a Nigerian spammer.

Normally we do not need this kind of "calculations". It is a common practice to store financial year date range in some master table, as different countries can have different...

A view without any Index, but bound with schema.

Does it gives any performance difference.

Parameters goes like this:

(isnull(@activity_id,0)=0

or

pd.activity_id = @activity_id)

and

...

It was 1 query. I split OR part mentioned below into 2 queries and used union. Now it is performing 65% better then earlier.

but still consuming a lot of time....

Some SELECT queries has complicated WHERE clause. I hope it will be supported.

Thanks.

If I go for SSIS, will it make any difference if source and target tables are on same database.