I am in an environment that during code review, if I ever write a stored procedure that uses a cursor, the reviewer always says, "Oh! Uhoh! Cursors are bad unless they are absolutely neccessary." Then ...

I have a table that's something like this:<BR><BR><pre class="ip-ubbcode-code-pre">CREATE TABLE thread(id INT, parentid INT, sometext TEXT);</pre><BR><BR>The values ...

Tim Chapman discusses your iteration choices in SQL Server 2008 and explains why determining which option performs better depends on the situation. In a previous TechRepublic column about SQL Server ...