Added to the list.

I've given up on searching that way, and only search using site search, unchecking boxes.

Without seeing more sp_who output, you can't determine that the checkpoint is blocking everyone. I might recommend you get a script for the block tree, or get sp_whoisactive and use...

Bru has the right idea. Depending on the load of I/O for your files, I'd move either the log files or tempdb to reduce contention. That assumes you have I/O...

OK, slightly confused. It would help to provide sample data.

Do you want the most common value on a day, or all duplicates? Meaning, if I have this

CREATE TABLE...

xp_cmdshell will allow you to call some things.

The code inside SQL Server are not the same as say the code from a C# or VB program. You don't have an...

This lists the default level as 1, out of 11 possible levels. 0 is no compression, which is the same as a native backup.

https://support.quest.com/search/SolutionDetail.aspx?id=SOL14764

If you are looking for a percentage...

I don't think this is a wide problem, and I have rarely seen anyone complaining about the checkpoint process.

If you run SP_who, is it there you see the checkpoint process...

jcrawf02 (12/14/2011)

---

I think the point that needs to be made here, regardless of viewpoint, is that you shouldn't care whether it's termed revenue or overhead. If you're helping the company,...

You are doing things backwards. Don't manage the admins this way.

If you don't need or want BuiltIn\Administrators as admins, then remove that group from the logins. However, before you do...

40F in Denver, no need for pants today.:-P

Hardly, too many articles to keep track of. :w00t:

That uses SSRS. While that's the preferred method, if you don't have an SSRS server, I don't want to give you another...

I would not expect that the client tools work on XP, but I'll try to test.

Verify the path, if it's not working, include some MSGBOX lines in there, and see what values are being sent for the files and folders. It's basic debugging here for...

I assume you are backing up your production database, correct? Just copy the latest full backup to the development server.

If you are replacing the databases on the Dev server with...

database permissions do not cross database boundaries by default. You can enable this, but be aware of the security implications.