At the moment, it retrieves all entries from the table despite having a filter condition. As you correctly pointed out, indexes don't seem to be significantly impactful in this situation....

Thanks for your comments.

I was looking for something similar to a xp_fixeddrives to use in T-sql. Guess I will have to do it using from OS side.

2 days old backup is clean. Is there no other way as I don't find any user tables corrupted.
Can you please share some more information on this error.

If you have installed and uninstalled few times on this machine, then there might be some objects remaining from a previous installations. In that case make sure to completely clean...

Thanks.

There is no need to guess. Here are few more examples.

_BF-TYPE:NICK_ _BF-SUBSYSTEM:SERVERS_

_BF-TYPE:CONFIG_ _BF-SUBSYSTEM:CARRIER_

_BF-TYPE:INSERT_ _BF-SUBSYSTEM:CARRIERS_

The patterns are consistent. Length of NICK and SERVERS can vary..

Why would you want to deny access to sysadmin ?

Any way to figure out which database is the one involved ?

That helps. Thanks a lot 🙂

Yes. I have seen that from BOL. But in my case giving public privilege returns only user 'sa'.

Checked dm_os_latch_Stats and the result is attached.

Attached screenshot has the top 10 waits.

Yes they are causing performance issues.

I could find high values for latch waits/sec. The page life expectancy is very high(so I came to a conclusion it is not a...

We have tuned the procedure now. It is being serially processed now. We need parallelism, and for that I believe we need more than one dialog. Not sure how to...