Arthur Fuller Intelligent Database Design Using Hash Keys Your application may require an index based on a lengthy string, or even worse, a concatenation of two strings, or... 17 February 2006 5 min read
Arthur Fuller A case for canned SQL Like a Phoenix, the dynamic SQL versus canned procedures and user functions argument has resurfaced on the SQL newsgroups. Many... 18 January 2006 4 min read
Phil Factor Cursors and embedded SQL The database mole turns his attention to take a look at cursors and embedded SQL… 19 December 2005 7 min read
Douglas Reilly Managing database changes Stored procedures are not the be-all and end-all of managing changes in a database, but they can be very important... 11 May 2005 8 min read
Douglas Reilly To SP or not to SP in SQL Server There have been a number of discussions about whether to use SPs or not, often shedding more heat than light,... 11 April 2005 16 min read
