Performance / Storage Comparisons : MONEY vs. DECIMAL
As you may already know, I am not a big fan of the MONEY data type, because of its inflexibility, accuracy problems, and the expectations the name of the type evokes in new users. ...
As you may already know, I am not a big fan of the MONEY data type, because of its inflexibility, accuracy problems, and the expectations the name of the type evokes in new users. ...
In a recent blog post, Dancho Danchev mis-labeled a recent IIS vulnerability as a "massive SQL injection attack." Let's be honest here. Yes, this alert needs attention. But this is not a new SQL...
Bob Ward posted a blog entry today where he explains the process of getting a cumulative update for SQL Server 2005 without having to call Microsoft's support team (they are called CSS now but...
Just wanted to post a brief warning about expecting to be able to roll back a cumulative update or hotfix by reverting to a restore point. In short: don't do it! These two features...
Microsoft has committed publicly to releasing Service Pack 3 for SQL Server 2005. Francois Ajenstat first talked about it very recently here. While there were some casual mentions of the release in some responses...
While playing with the new Policy-Based Management (PBM) features of SQL Server 2008 the other day, I came across a really annoying syntax implementation that is going to trip up a lot of people...
It is 2008. Not 1992. Why are we still intentionally creating filenames that conform to the limitations of ancient DOS and Windows 3.1 naming standards? This came up today in one of the SQL...
No, this is not a "funny funny, ha ha!" April Fool's Day post (though I do find those entertaining, and considered posting one myself). This is for real, and it almost made me tingle...