Hello, try to follow below steps  

1. Click on "Start" go to "RUN" type mmc (memory management console)

2. Go to File--> Add/Remove snap-in

3. Click on the Add button...

hi

As per execution plan,there are be four identical temporary indexes created. I guess this is problem with CTE. I always try to use CTE part as subquery.    

Yes you are right !! It depends and I am agree with processing data from  remote server is bad design. If the performace is only creteria for putting database in different server,...

I agree with what you wants to suggest. My concern was when one application supports 2 or more databases say 1.Metadata DB: which store applications metadata  2.Client DB: which stores user specific...

A possible business requirement

I could have application where I setup client data database and metadata database on two different servers. In such cases clients database might need some business logic from metadata database in the...

Not really, the columns can be all Int/char or combinations of int and char.  

Hi stax, thanks for suggestion but in my case both the table and columns get generated dynamically during process. Here is query I want to optimize. creating non-clustered index is not much...

Hi Tim, I am 100% agree that making MAXDOP = 1 is not the solution to be implemented and indexes on the columns participating in join should have non-clustered indexes....

Hi Tim

  Thanks a lot for the help. I got the isuue, it was with MAXDOP. some more info about the problem..

"The sys process info tells...

Yes, I know..sorry for not giving all information. We have an application where user create the tables and they are named as T434_....

The above query is puting matching rows between two...

Hi

 Thanks for the reply.. I found more simpler one

declare @t table (Recreate_flag bit, Update_flag bit, Append_flag bit)

insert into @t

select 1,0,0 union all select 0,0,1 union all select 0,1,1

select...

Hi.

Select name,type_desc from sys.tables where large_value_types_out_of_row =1

Hi,  For your ref

SQL Server 2000 stored procedures return data in four ways: Output parameters,Return codes,A result set for each SELECT statement,A global cursor that can be referenced outside...

Hi

 This will help you.

 http://www.microsoft.com/resources/documentation/msa/idc/all/solution/en-us/rag/ragc06.mspx

Hi  This was i was looking for, functionality of nulls shall be as follows. I think jesper had replied for that.  Thanks...a lot ..