Category Archives: Databases

January 30, 2007

ColdFusion UUID and MSSQL newID()– also posted in ColdFusion

A lot of web applications these days use a UUID as the primary key instead of the int/identity combination (speaking for MSSQL that is). Now there is a (valid) argument that UUID’s aren’t great for primary keys due to the fact that primary keys are clustered, meaning that integers would work much better if the [...]

January 11, 2007

To delete or not to delete– also posted in ColdFusion

As a web developer you are constantly faced with building functionality to remove an object from an application. The object could be anything from a web page in a CMS to a user in a CRM, but generally involves a record(s) stored in a database. For a user ‘using’ the application whenever they access the [...]

July 26, 2006

Truncating MSSQL transaction log

Every wanted to truncate the transaction log of a MS SQL database? We do that all the time when moving a database from one server to the other. Remember that the transaction log can take up a LOT of space in the backup file which you don’t need when you are simply moving a database [...]