Thanks Grant/Steve. The show statistics option sadly doesn't work with SQL Server 2012 but I will dig further down the statistics route with Extended Events and see what I can...

Cheers guys.

The final code does include a Begin/End as part of the Table Valued Function so will be the same as you describe.

I will use this going forward, thanks once...

Cheers guys.

I am working through the current environment at the moment in a bid to try and re-write the functionality of Scalar Functions and have come across instances where just...

Thanks for the reply Gail. With there being such few rows I expected the Table variable to perform similar to the Local Temporary Table.

The more I use Table Variables (variant...

Thanks for the reply.

Everything has been checked and double checked, it's not the 1st time I have installed SQL in a clustered environment.

Both (Server1) and (Server2) are identical in every...