I have a software called iCare running on my SBS 2008. It is a healthcare software.
Runs on IIS and SQL Express 2008 R2 for database.
The process sqlserv.exe occupies around 50% of the CPU on most occasions and keeps going upto 100% CPU every few minutes. I think this happens when a query is run by the users.
In particular there is a module called Add Activity in the software which freezes 8 times out of 10 and comes back with an error SQL Exception. This is when the Silverlight goes round in circles and circles and throws this exception.
I think its not right for the process to occupy that much CPU. The database goes very slow and its very frustrating. where do I start? I am not great at SQL.
In this article, we will see two different methods to recover deleted data. The first option will be using the transaction log to identify the operation and restore it in a specified section of the transaction log. The second option is simpler and c…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…