Installing SQL Server 2008 Express
November 12, 2008
Installing SQL Server 2008 Express - you'd think it would be simple, but you'd be wrong! here are the steps you will need to go through (on Windows XP at least!) Read more »
Maximum list values for cfqueryparam
October 22, 2008
I've just managed to get ColdFusion 8 to blow up MS SQL Server 2000! This is the error message I was getting: [Macromedia][SQLServer JDBC Driver] The DBMS returned an unspecified error. The command code was 0. Read more »
Use Subqueries - they are fast!
September 05, 2008
Using SQL subqueries can give your huge performance gain over manipulating recordsets with ColdFusion. Read more »
Using Identity insert
June 26, 2008
I was looking at Todd Sharp's getGeneratedKey function on UDFLib, which returns the identity (auto generated primary key) when you insert data into a database. It works by making use of the result attribute of cfquery, that was introduced in ColdFusion 8. This lead me to think about what ColdFusion was doing under the hood and how you could do it with older versions of ColdFusion. Read more »
Search for % sign in SQL.
June 25, 2008
MS SQL server uses the percentage sign (%) as a wildcard when you use the like operator. So what if you want to search for the percentage sign? Read more »
My DAO/Gateway hybrid
June 19, 2008
As a spin off of my post An ORM sceptic a few people have asked me how I handle my database interaction. So here it is... Read more »
Extract Time from DateTime field
June 16, 2008
I had a problem in MS SQL Server, where I need to do some calculations on the time part of a datetime field, to see how many people had arrived late for the job they were booked for. Normally I'd use the DATEDIFF function in SQL Server. For example: … Read more »
cfparam, SQL Server and datatypes
June 02, 2008
This one always catches me out, so once and for all I'm going to post it for future reference! If you use the attribute values of "cf_sql_numeric" or "cf_sql_decimal" for decimals then they are rounded to the nearest integer. Read more »
Using Query of Queries to improve performance
May 28, 2008
I'm pretty sure that this has been blogged about before but I thought it was important enough to write about as some people may not have seen it or forgotten! I am currently building an application that requires a lot of database interaction. I've d… Read more »
Performance gain with Subquery instead of group
May 12, 2008
I've often used SubQueries in SQL for filtering data, but I've not tried using one in a select statement. I recently had a query that was running slowly due to the number of fields referenced in the group by clause. By changing it to use a SubQuery in the select it has actually reduced the execution time. Read more »