THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web
Browse by Tags
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 ...
Michael Coles: Sergeant SQL
April 3, 2010
Yet Another Stored Procedure vs. Ad-hoc Query Discussion?
Earlier today, Will Sullivan posted a blog entry, My Statement on Stored Procedures, in which he emphatically states his official opinion of stored procedures as: ''I prefer not to use them.'' He then goes about dismissing most of the misinformation about why stored procedures are better than ad-hoc (parameterized) queries. The first bit of ...
Peter DeBetta's SQL Programming Blog
April 3, 2008
Brought to you by