What does empty mean? Does that mean you want to export the data or you want to delete all the data?

Which steps produced the error? If this comes from Configuration Manager than you may have something broken or corrupt in your installation.

Do you have encryption set? Does this apply?...

It's only Wednesday!!!!!! Feels like Friday afternoon to me

Of course

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