Can you post the SQL you're using? I'm seeing part of it in the plan but it cuts off.

Make sure you're testing on data that's similar to production because query plans can change with different data sizes and distributions.

For the product I work on (external support only) L2 deals with the client's IT staff, has minimal visibility into the code, and can't made code changes (although some of...

I've used WinDirStat to track down files to delete to free up space. I would make sure you keep a list of what you delete and then try to...

If that process is blocking others you'll need to either find out why it's running so long or stop it.

That was my only thought. Hopefully someone else comes along with another idea.

I'm not aware of a way of restricting CPU percentage but if it's a multi-processor machine you can set the maxdop for the query.

If the queries aren't completing I would check for blocking using Activity Monitor.

Select statements don't change any data so they aren't logged.

Check the charindex function to find the decimal and the substring function to get the third position after that. You'll need to convert the column to a varchar first.

Can you send the call you're making to the procedure? It looks like you're not passing in something for @CandID but we'll need to see the call and how...

Will something like this work:

select myCol, count(*) from myTable

group by myCol

order by 2 desc

It looks like it still needs to scan the whole table for this:

SUBSTRING(LineRead,

CHARINDEX('/',LineRead,CHARINDEX('/',LineRead)+ 1)...

What about splitting it into two databases and setting up either views or synonyms to reference the objects that were moved? That should make the change transparent to anything...

Another option would be to set up individual SQL accounts for each user and not use shared accounts.