I've 100 concurrent users. Looks like 16 GB RAM is so small for SQL Server 2012 Standard Edition / Enterprise Edition

Here my function

CREATE FUNCTION [dbo].[fn_Split](@text varchar(8000), @delimiter varchar(20) = ' ')
RETURNS @Strings TABLE
( 
position int IDENTITY PRIMARY KEY,
...

Hello Jeff,

I want to reduce deadlock. That's why I want to make it short @ Single Statement

Hello Sir Jonathan AC Roberts,
I mean - How all Insert, and Update statement into SINGLE STATEMENT

My bad said...