While I realize this would eat into the total available learning time, I tend towards the "learn skills that are useful for your current job, while also spending time learning...

It's amusing to post a reply to a blog post, which is asking people to try to guess where some really janky SQL code came from (but not give away...

Another thing to check is, what is the data type of the key column(s) of the index?

I've got several tables with 90+% fragmentation which I don't even bother...

The only way you're going to track down that information is if you already had a SQL Audit or a security-related Trace running at the time the access was lost.

Regardless of the tool used, your full backup is going to take a fair amount of time.  Keep in mind, the backup only backs up the *DATA* not the file,...

A year or so back, I convinced a customer with a database on my servers to go the route suggested in the article.  The application in question has an MS...

Based on the fact that you said the query ran fine again in production after you did index maintenance (I'm presuming reorganized) and updated statistics, most likely your statistics in...

I would think you could do this using the Resource Governor feature.  Create a resource pool to limit the CPU usage for the login in question.

Please note, I...