Viewing 15 posts - 1 through 15 (of 18 total)
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...
May 23, 2025 at 2:56 am
[deleted]
May 23, 2025 at 2:56 am
You should clear the @TSQLFilename variable on each loop, or it will just keep growing and will not work beyond the first loop.
January 27, 2025 at 3:05 pm
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...
June 19, 2024 at 9:35 pm
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...
December 28, 2023 at 9:10 pm
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...
March 22, 2021 at 8:17 pm
June 11, 2018 at 10:11 am
June 8, 2018 at 12:02 pm
June 8, 2018 at 11:59 am
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...
June 8, 2018 at 11:07 am
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...
June 28, 2016 at 2:44 am
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...
March 18, 2016 at 8:14 am
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...
February 19, 2016 at 9:03 am
Ed Wagner (1/19/2016)
January 20, 2016 at 12:32 pm
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...
January 19, 2016 at 4:30 am
Viewing 15 posts - 1 through 15 (of 18 total)