May i know the cause?

-- @NotificationsStatus is table type variable

UPDATE n

SET

n.Name = ns.Name,

n.EmpCode = ns.EmpCode,

n.EmailProcessingStatus =

CASE WHEN ns.EmailProcessingStatus IS NOT NULL THEN ns.EmailProcessingStatus ELSE n.EmailProcessingStatus END,

n.MobileProcessingStatus =

CASE WHEN ns.MobileProcessingStatus IS...

UPDATE tbl1

SET

column1 = CASE WHEN @Values1 = 1 THEN @Values1 ELSE column1 END,

column2 = CASE WHEN @Values2 = 1 THEN @Values2 ELSE column2 END,

column3 = CASE WHEN @Values3 =...

I need to update multiple column, so i dont think IF ELSE is good thing to implement, have to check for each column in separate statement.

I have used CROSS APLLY, it worked fine for me. udf is having 1000+ line of codes and sp is also too much so not able to paste here and...

Id columns i have just given for reference, in my case TVF will always return 1 row but in table may have multiple id. So i think it should...

Does CROSS APPLY will not produce duplicate result set in case employee table have duplicate id?

Does is support Day Light Saving as well ?

Yes, I know the zone of saved date. Other than this i have saved date in UTC but in this case i need to save date of local time with...

Once user start accessing application then only it lead to 100% cpu consumption.

Yes, Because in one of my query, i am joining with 3 tables. And table 1 have the 1 million record, 2 Lakh and table3 have 10 thousands.

I am using...

I have checked by Query, And also at time when our IIS server was stop CPU usage was 0 %, if we start IIS server and user accessing application it...

it is charging few dollars, i have to take approvals from client.

I ran SQL Profiler and saw many sp_resetConnection, AuditLogin, AuditLogOut.

I have 1 doubt i saw continue Audit Login and Logout. There were not actions between login and logout.

They...

Yes i checked, .Net SqlClient Data Provider as program name was consuming most.