Gail - we do need point in time recovery. I do full backups every Friday night at midnight, differentials every other night at midnight, and log dumps every hour....

Thanks, Gail. I read through it, and I understand what the log is and how it's used. But that failed to answer my question. Basically, of the...

Yes - I indicated in my original post that I shrink the log just before I get a full backup.

The developer has left for the day, so I'll see if I can get some info from him tomorrow and post it!

The developer found some things and released a fix about 2 hours ago (he's a pretty sharp guy). I've been monitoring our servers closely ever since, and the CPU...

PROGRESS!!!! Thanks to your script MarkusB, I was able to identify a stored procedure that was running every time the CPU spiked. The developer ran tests on our...

I have a maintenance script that runs once a week, and part of that rebuilds indexes. I also rebuilt the indexes immediately after the release, so they have been...

Thanks Markus - I'll try that too.

For all of you offering help (which is HUGELY appreciated), I'm actually in the middle of this problem at this very minute. What...

Colin - I have a question for you... you said it's not easy to map CPU% to a specific sql query. I'm not anywhere near a SQL guru...

Thank you, Colin - that's certainly a terrific start!

Thanks Steve - I didn't even know about that site, but I've already bookmarked it!

Look - I appreciate the answers to my questions - I really do. You've been most helpful in that respect. But I honesly feel that, until you know...

Jeff - he is a beginner, this is his first job out of tech school, and we hired him because we saw his potential for learning. I never suggested...

I'm crying from laughing! GilaMonster, the SQL book upside the head has already been considered - we're just trying to determine which book in our vast library here in...

Thank you both for the replies! My questions were for my own knowledge, but they stemmed from a query that one of our developers uses constantly:

SELECT TOP 1 *...