Ask about nearly any kind of SQL-based date calculation in the newsgroups, and you'll likely get responses that include use of an auxiliary calendar table.  It's a really good idea, and something I highly recommend to anyone who has to do date-based calculations on the server.  For those who do dimensional modeling, you'll probably ...

On the SQL Server public programming newsgroup someone recently posted a question about an SSMS error (''Cannot parse script. 'System.OutOfMemoryException' thrown.'') I hadn’t encountered this error myself, but the workaround is to break up very large scripts (50+ MB) into smaller scripts. Adam Machanic posted a T-SQL Tuesday challenge to post a ...