Except there is no such thing as self-documenting code. The problem is code needs to be concise to the point it loses context. You keep that context in your...

[deleted]

• This reply was modified 5 months ago by Brain2000.

You should clear the @TSQLFilename variable on each loop, or it will just keep growing and will not work beyond the first loop.

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