THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQL 2008 » t-sql » SQL Server   (RSS)
  • Bit-Twiddling in SQL

    Someone posted a question to the SQL Server forum the other day asking how to count runs of zero bits in an integer using SQL.  Basically the poster wanted to know how to efficiently determine the longest contiguous string of zero-bits (known as a run of bits) in any given 32-bit integer.  Here are a couple ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on April 3, 2010
  • Calculating Holidays in SQL

    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 ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on February 25, 2010
  • Parent-Child Build Scripts with SQLCMD

    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 ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on January 10, 2010
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement