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 -

Proximity searching in sql server

Just need to keep track of this for future ussage. After a bunch of googling this was the clearest example of doing a proximity search in SQL Server that I could find.

implementing a proximity search in sql server

(Via Googling.)

0 comments | Posted by Daniel Short on Jan 21, 2009 at 3:27 PM | Categories: ColdFusion -