Hi Gail,

I understand what you are sawing. What I am looking for is, is there anything we can check inside the database through which we can get some free space,...

200 MB is amount of Free space left over in H:\ drive where all our data files i.e. mdf and ndf's are located. we maintain a separate drive for...

Thanks for the inputs. Will try the server side trace on both Srv1 and Srv3 and look at the data.

Thanks Gail and Alan. Many thanks.

Is there a way using dmvs / trace to get know the the timeout set for a query? I can ask the application team but I am curious to know...

Hi Gail,

You mean create indexes and do some query tuning to speed up queries?

FYI we are pulling large datasets from different source systems and load data into a...

Thanks Alan.

I have one more question, how to handle / avoid query timeouts?

Thanks Jeff for the detailing.

Thanks Scott.

Below code worked for me

select c1,c2,c3 From numbers

where c3 <> 'CP-961080'

union all

select c1,c2,c3 From numbers

where c3 is null

Thank you Dixie.

Thats Awesome Eirikur Eiriksson. Other thing, it came into my mind looking at the Execution Plan, I see sort and the Merge join is happening.

Is there an way, we...

Hi Eirikur Eiriksson thanks for your inputs.

If you don't mind, could you please provide me a demo script for my example using CTE's to avoid implicit conversions?

Thanks for sharing your thoughts Eric.

This is a datawarehouse system where we have Cleansing database where we pull data as it is from source systems. so, i cant change the table design and this is...

Thanks Kevin for sharing your thoughts.