JOIN HINTS

Get Set For Speed

Loops are common in application code, but set-based solutions are the way to go with SQL.

Virtual tally table function

An inline table-valued function (iTVF) that will produce a virtual tally table on-the-fly. The function creates a tally table of any size with user-defined lower and upper bounds.

Loop Through every table in a DB

This Script has been build to list all the tables in a database without using a cursor.

Cursors Be Gone!

A short tutorial on converting cursors to more conventional loops.

RE: Question of the Day for 07 Sep 2004

The answer is not incorrect but the wording is a bit misleading. While it is true that adding 'not null' changes the outcome, it is not true that the column will be filled with 'N' automatically as such.Regards

RE: Question of the Day for 31 Aug 2004

I tried this in QA and I got the following error message...View or function 'MyOrders' is not updatable because the modification affects multiple base tables.This would suggest that the answer "You cannot do this as the view contains multiple tables." is more correct than "You cannot do this as the update references two tables."just my […]

RE: Are partitioned views not that smart?

Hi John,Newbie or no, you are correct: you need those check constraints.  But if you looke further back in this thread you'll see that we've discussed that a bit already.  Friendly user mssql_rules has indicated that their view meets all those requirements for partitioned views, and that he can in fact update through them.  If […]

RE: SQL smalldatetime and MS Access default

What about DTS. I think it is handlening it

RE: Writing to a log within a stored procedure.

the Log RAISEERROR uses are the Windows Application Log and the SQL Server Error Log!!!!