I found a tip here a while ago that said there was a faster way to get the record count than using count(*)

SELECT rows FROM sysindexes WHERE id = OBJECT_ID('tblUsers')...

Are you using a cfqueryparam to insert the data into your table?  That would probably help. 

Are you converting the data from the form using HTMLEditFormat or HTMLCodeFormat?  That would convert...

Thanks very much -- I actually realized that after my post and it solved the problem. I am creating a dynamic SQL statement for the search and so I...

Is there an advantage in putting the inequality in the join statement rather than in a WHERE clause? Does the query run faster?

example:

SELECT s.CourseID,s.SectionNumber,

c.RoomCapacity, s.SectionCapacity

FROM tb_ClassSection...