chapter31

development in a land far far away…

at the moment

History is not what happened. History is what was written down.

Archive for the 'Databases' Category

To delete or not to delete

Thursday, January 11th, 2007

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 functionality [...]

Read the rest of this entry »

Truncating MSSQL transaction log

Wednesday, July 26th, 2006

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 [...]

Read the rest of this entry »