SQL Server
Topics that discuss SQL Server administration or development.
I found another oddity that seems to be undocumented today. This one in SQL Server 2005. Apparently, you cannot start objects (at least stored procedures) with the word "Log". I have a table called ShipNoticeLog and a stored procedure called LogShipNotice. The table is the noun and the stored procedure is the action -- this is how I prefer to do the naming. My code quickly failed with the message, "Invalid object name 'LogShipNotice'..." I ended up solving my issue by renaming the stored procedure...
I finally got back to reading some of my “Introducing Microsoft SQL Server 2005 For Developers” book and I stumbled upon the topic of user defined aggregates (UDA). I think this is an interesting subject, although probably only useful in very distinct scenarios.