Thanks for this useful information. Could anyone please also advice what is there is SQL 2014 for below Component Class IDs. Below ones are from 2008: -
body { margin: 0...

Hi!

Please assist that "Order By" clause is necessary in this query and is there any wrong outcome if we do not use this Order by clause? Please share the info....

Hi! The data is not going to a web page. It's a SSIS package which process this task and then provide this data to sucessor tasks or other processes. there...

PFA the ExecutionPlan and please advice.

Hi!

First of all can't separate the OR. and tried this but, getting diff. in output of 5417 rows (may be due to some rows have values in both columns. ...

Hi! Then how do we improve it?

Hi!

This SP has

an initial query to load data in temp. table with 5 tables joins. This query executed within 15 seconds.

Then...

Hi!

Actually the other processes depends on data of this table are also getting the data on daily basis and the volume is also same and some time on higher side....

HI! As per my understanding posted almost all info. about the problem. Please let me know what exactly you required to solve this problem. I am really eager to have...

Dear,

OK. I did not add this login under db_Datareader role that is the reason he is not able to perform SELECT statement.

But, I added this user under "db_Datawriter" and...

Dear,

Yes, I tried it & got successfully done. But, please reply on this: -

for a while if we not do your mentioned process and assign all these 3...

Dear One,

I got your point. To avoid overhead we are creating a new role as per our requirement. But, for a while if we not do so and assign...

Dear one,

Thanks for the quick response. But, can you please explain why we are adding a new role and then adding this role under "db_ddladmin", "db_datareader", "db_datawriter" roles?

Need to understand...

Sorry! I am asking for SQL 2000 version. In SQL 2000 we can achieve the same by UNION or by using multiple temp tables or any other way which reduce...

Dear Fitz,

Thanks for the reply! the query is giving the output as per the requirement. But, what if we are using SQL 2005??? Is there any way by which...