Please stop using SELECT MAX(id)

Posted At : June 1, 2008 10:00 PM | Posted By : Adrian J. Moreno
Related Categories: SQL, Primers

I know there are a lot of tutorials that use this technique. I also know there's a lot of inherited code (in any language) that contains this SQL. I also also know that - years ago - I too was a slave to SELECT MAX(id). But this is the 21st century and you need to stop using it.

[More]

Comments (13) |

Print |

Send |

del.icio.us |

Digg It! |

Linking Blogs | 4503 Views

Thou shalt not query thy database using SELECT *

Posted At : March 27, 2008 3:32 PM | Posted By : Adrian J. Moreno
Related Categories: SQL

Usually I just bookmark blog posts via Del.icio.us, but I really wanted to point out one of Ben Nadel's posts Easy Tips For Writing Better, More Optimized SQL. Hopefully he'll supply some examples in future posts, but the concepts he covers are a must for anyone writing SQL with or without ColdFusion.

Comments (2) |

Print |

Send |

del.icio.us |

Digg It! |

Linking Blogs | 779 Views