Pretty cool, just one thing to consider.

SQL is the most expensive CPU license that one might pay for.

For that reason, I'm out...

I've been setting up bare metal SQL servers since SQL 2000, and I always set the max memory to the total memory - 4GB reserved for the operating system. I...

One other reason this can happen is if you have the data folder on the root of a drive (i.e. a drive used exclusively for MDF files).

For example, if we...

I find comments are easier to return to months or years later if you leave out almost all articles, such as "it" or "this". There's nothing like looking back and...

There were two items in this article that I feel need to be clarified.

The article stated that cumulative updates are not fully tested like service packs. While this was once...

Keep in mind that a local temp table can disappear on you if you mix queries that require separate connections. A new connection will be created without you knowing...

Is it possible to disable cross joins for either a specific login, database, or server (or combination) for production servers? I find cross joins to be a security risk...

Ed Wagner (1/19/2016)

---

Network operations frequently has a monitor in place, but it doesn't do forecasting or keep history. By the time the drive space is so low that an...

I'm currently using an external monitoring software to let me know when I'm getting low on space. In this case I am using Nagios. It keeps the free space history...

This method seems absurd, yet it may be the only way.

The RESTORE FILELISTONLY columns change periodically, thus breaking scripts.

Is there a way to do a SELECT INTO?

I know it's been a few months, so you have probably fixed this one way or another.

I have the situation where I have to keep databases online. Data integrity...