Please post new questions in a new thread. Thanks

Can you post the deadlock graph?

Yes. Don't concatenate input into strings to be executed unless completely unavoidable (eg table names and column names), if...

There's probably some implicit conversion happening somewhere in the LINQ such that the value is getting cast to the LINQ equivalent of DATE before the insert.

You need Dynamic SQL, you can't parameterise a table name. Build up a string, execute it.

And yes, people are paranoid for good reason, which is why you will check that...

Can you use Profiler to show the exact INSERT sent to SQL Server?

IF @State = 'AZ'

UPDATE AZ_Fees

SET @ColumnName = @NewValue

WHERE ID = @ID

IF @State = 'CA'

UPDATE CA_Fees

SET @ColumnName = @NewValue

WHERE ID = @ID

...

Alternately, use dynamic SQL and check that the table name...

DATETIME is accurate to 3 milliseconds. It won't convert a time to midnight

Check the LINQ make sure there's no rounding/conversion happening. Also check there's no trigger on the table.

What's the exact error message?

Can't see the image, but don't use Task Manager. It lies.

Performance monitor, the process object should help. It'll probably take a lot or work.

Increasing memory will help, bump to 32,...

And the second query?

hadihalim90 (6/27/2016)

---

My problem is, can I reduce the maximum server memory to 4096 MB to rectify this issue as it is on production now? I have checked on the application...

If you run these, what's the result for the database you have the problem with?

DBCC SQLPERF(LogSpace)

SELECT name, log_reuse_wait_desc from sys.databases

angelreynosog (6/27/2016)

---

There is no defined structure as such , this is why I'm looking for guidance , how could. Currently , it is being done as I said , Backup...

What recovery model are you in?

How often do you back up the transaction log?

What's the maximum allowable data loss for this DB, in the case of a disaster?

Please take a...