Hi Grasshopper,

Thank you for your suggestion. I will check out the tool SQL Sentry Plan explorer.

Have a great day!

Best Regards,

Hi Grasshopper,

Yes. In terms of performance (duration, reads, CPU, IO).

Thank you.

Best Regards,

Hi Lowell,

Thank you for your reply.

The link that you sent is very helpful. Thank you for sharing it.

Have a Great Day!

Best Regards

Ricky

Hi Mr. Grant,

Thank you for your suggestion.

I've read both your books SQL Server Execution Plans and SQL Server Performance Tuning and I've learned so much from it. I keep...

Hi Eirikur Eiriksson,

Thanks for you reply.

Okay. I will check with our client's network team whether or not they have opened UDP port 1434.

I will send an update soon.

Thank...

Hi Eirikur Eiriksson,

Thanks for your reply.

the SQL Server Browser is running and active.

By the way, Im trying to access the ServerName\I01 instance from a different server within the same domain.

There...

Hi tan110,

We need to enable CLR because the integration services catalog uses CLR procedures. Integration services catalog has to be created on the server in order to be able to...