SQL to get minimum value based on a filtering option

Here is a great articles that I came across that explains in detail on how to select a minimum value from a column based on a particular filtering option.
The example listed here was how to select the cheapest price for the different categories of fruits.
http://www.xaprb.com/blog/2006/12/07/how-to-select-the-firstleastmax-row-per-group-in-sql/

SQL Script to search inside stored procedure

A little useful script for searching in stored procedures.
SELECT OBJECT_NAME(id)
FROM syscomments
WHERE [text] LIKE ‘%searchtext%’
AND OBJECTPROPERTY(id, ‘IsProcedure’) = 1
GROUP BY OBJECT_NAME(id)

SQL Server Generate Change Script From Table Design View

This is something that I just found out existed today, probabily due to my lacking of actually going through the tool bar.
In SQL Server 2005, in the design view of table, usually you can perform a number of changes here like adding a new column, changing the column size etc, if you were performing these [...]