Last year I discovered the "Monster Hunter International" series.  They're a relatively fun read (if a bit grim sometimes.)  There's a new one due out in a month or two...

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...