Category: ColdFusion

Ad-hoc database change monitoring

Gonna have to give this a try soon...

arc90 lab : tools : SqlWatcher: Ad-hoc database change monitoring

0 comments | Posted by Daniel Short on Feb 5, 2009 at 10:58 AM | Categories: ColdFusion -

Finding Missing Indexes

I learned yesterday that SQL Server will tell me which indexes it thinks I need to have. Just use these three queries to get a look at what your SQL Server thinks you should be doing to take care of your queries select * from sys.dm_db_missing_index_details select * from sys.dm_db_missing_index_groups select * from sys.dm_db_missing_index_group_stats
0 comments | Posted by Daniel Short on Feb 5, 2009 at 10:18 AM | Categories: ColdFusion -

cfselect, binding, and selectedvalues

ColdFusion's cfselect doesn't support the selectedvalue argument when using binding. I don't like the JavaScript solutions out there, so here's a simple SQL solution.
Read complete post
7 comments | Posted by Daniel Short on Jan 22, 2009 at 10:21 AM | Categories: ColdFusion -