Check out openquery() to access data on linked servers. It will return only the results of the query after processing the query on the remote server.

From a recent experience we faced both issues, old servers and less than optimized coding.  As we scaled larger, the issues with providing reliable and timely service escalated to the...

To access large remote objects, you should check out the openquery() options for data access to linked servers.  It can often provide better performance by executing the query on the...

Only trying to point out a couple of concepts I haven't seen used much.

The function parsename and update on insert trigger inner joined to the inserted table are simple ways...

As long as the [id] is unique/primarykey the inner join should update only those records in the inserted table that have just been inserted into the master table. 

Why not try the update with concept like this ?

 UPDATE SMS SET

    sms.Part1 = REPLACE( PARSENAME( REPLACE( REPLACE( i.Message, CHAR(46), CHAR(124)), CHAR(44), CHAR(46)), 4), CHAR(124), CHAR(46)),

    sms.Part2 =...

Check out the Parsename function.  If you always have four pieces of data they can be retrieved by replacing the delimiter with a "."

parsename(replace(fieldname,',','.'),4)

parsename(replace(fieldname,',','.'),3)

parsename(replace(fieldname,',','.'),2)

parsename(replace(fieldname,',','.'),1)

not the intended use of the...