Tag Archives: SQL

Eleven Coldfusion-ish tips from the field

Posted on 02/20/2011 by Eric Fickes

I’ve had this running list of Coldfusion tips on my wall for the last few years and it’s time to get these online.  All of the items in this list came from Coldfusion projects over the last few years, but … Continue reading →

Posted in adobe, coldfusion, database, tips and tricks | Tagged , , , , , , , , , , , , , , | 10 Comments

Today I took 30 minutes to save hours

Posted on 01/03/2011 by Eric Fickes

UPDATE – 1/6/2011 : Since writing this post I have bundled this entire reset process into a single windows batch file. In addition to restoring my database, I also have to remove temp files from my server, so it was … Continue reading →

Posted in database, development, SQL, tips and tricks | Tagged , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

Selecting random ids using TOP and a CTE

Posted on 09/29/2010 by Eric Fickes

While testing visualizations in a Flex application, I needed to do some underlying data cleanup in SQL Server.  One of my tasks was to manually update an entity table and set the status column to one of three possibilities.  Status … Continue reading →

Posted in database, SQL, tips and tricks, tsql | Tagged , , , , , , , | Leave a comment

Use SQL to insert a label in front of a DataBound list

Posted on 06/09/2010 by Eric Fickes

Here’s a clever little solution I would like to add to the book of ‘get it done’.  While this particular example uses ASP.NET controls, this concept really applies to any language that supports DataBinding to a control. The base concept … Continue reading →

Posted in .net, database, SQL, tips and tricks | Tagged , , , , , | Leave a comment