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.

The filegroups matter. If you have other files in the filegroups that contain the full files, then the other files will be receive data. SQL Server sends data to filegroups....

There is a free SQL Search tool from Red Gate that will integrate into SSMS and let you quickly search for objects.

Disclosure: I work for Red Gate