While I have used BETWEEN in many places, there may be a problem missing the last second or minute of the day when the time is included, and it depends...

This got me a few times in queries where I've used BETWEEN @FromDate AND @ToDate in the WHERE clause, and the data type may be either smalldatetime or datetime. If...

I had this problem with one database not showing. I fixed it by noticing that although the username I was using in the linked server existed in the missing...

I've only worked on my own functions, and have looked at execution plans to compare the with and without. I have created some queries, without using functions, that had to...

I've seen the T-SQL for a maintenance plan (view only) with a disclaimer that it may not be exactly what the server will be executing, but see no way to...

I meant PostgreSQL over MySQL, not SQL Server (which is really just an old fork of Sybase).

MySQL is not totally free for commercial purposes, and the recent purchase by Oracle...

OK, I admit that I'm not a fan of proprietary software that limits me, costs more than I could afford on my own, and for which I have trouble getting...

Thanks for your reply. At least I now know what to keep in mind when I'm in similar situations.

You mentioned arguments over normalization with your devs, but didn't say...

Whatever the main premise of your article, you mentioned a "very simple four-way join" that "took ten times as long" in PostgreSQL as it did in SQL Server. I...

I had that problem. The problem was that the user name text box contained ".\SQLServerAccount" and the "." was being used as the computer name or domain name by WMI...