Database Troubleshooting
Resources
Following are blog entries or other resources related to this subject.
General DB Troubleshooting Resources
- Query Caching Run Amuck: Know Your FIFO Buffer (blog entry, Mark Kruger, 2010)
- Good Developers Practice Safe Query Caching (blog entry, Mark Kruger, 2010)
- Spying on ORM database interactions: Hibernate, Transfer, etc. on any CFML engine (blog entry, Charlie Arehart, 2009)
- Client Variable Database and Reserved Word Alias (blog entry, Mark Kruger, 2009)
- New for CF9 (and 9.0.1): a query timeout that really works, with a caveat (blog entry, Charlie Arehart, 2010)
- Cached Plans and Static Variables (blog entry, Mark Kruger, 2008)
- Can Performance Suffer With Cfqueryparam? (blog entry, Mark Kruger, 2008)
- The Dreaded Mismatched Column or Data Type Error Revisited (blog entry, Mark Kruger, 2008)
- Ask-a-muse: Proper Use of Cachedafter (blog entry, Mark Kruger, 2008)
- Bug with Query of Query: using LIKE incorrectly finds records with null values (blog entry, Charlie Arehart, 2008)
- Datasource Timeouts and Support for CFQUERY Timeout Attribute (blog entry, Steven Erat, 2006)
- Why You should worry about your execution plan (blog entry, Mark Kruger, 2005)
- Connection Pooling Deadlocks with User-based Security Models (blog entry, Steven Erat, 2005)
- Changing Database Schemas may require a restart of CFMX (blog entry, Mark Kruger, 2005)
- Connection Pooling and User-based Security Models (blog entry, Steven Erat, 2005)
SQLServer-specific DB Troubleshooting Resources
- Hanging JRUN Threads, MSSQL and Parallelism (blog entry, Mark Kruger, 2011)
- Processor Usage in MSSQL (blog entry, Mark Kruger, 2010)
- Data Truncation Error: Migrating MySQL to MSSQL (blog entry, Mark Kruger, 2009)
- Migrating Between MySQL to MSSQL (blog entry, Mark Kruger, 2009)
- Got problems with SQL Server tempdb? Here are some resources (blog entry, Charlie Arehart, 2008)
- Migrating to MSSQL 2005 and UNION Queries (blog entry, Mark Kruger, 2008)
- Having problems with SQL Server/Oracle/DB2/Sybase? Check out Confio Ignite (blog entry, Charlie Arehart, 2008)
- Several SQL Server Performance Tuning how to's (blog entry, Charlie Arehart, 2008)
- MS SQL's Casting Causes Consternation (blog entry, Mark Kruger, 2006)
- More CF and DTS Troubleshooting (blog entry, Mark Kruger, 2006)
- DTS Over Coldfusion - Revisited (blog entry, Mark Kruger, 2006)
MySQL-specific DB Troubleshooting Resources
- Validation Query for MySQL communications link failure (blog entry, Steven Erat, 2011)
- Data Truncation Error: Migrating MySQL to MSSQL (blog entry, Mark Kruger, 2009)
- Migrating Between MySQL to MSSQL (blog entry, Mark Kruger, 2009)
- Having problems with SQL Server/Oracle/DB2/Sybase? Check out Confio Ignite (blog entry, Charlie Arehart, 2008)
Oracle-specific DB Troubleshooting Resources
- Coldfusion and Oracle 8i Performance (blog entry, Mark Kruger, 2008)
- Having problems with SQL Server/Oracle/DB2/Sybase? Check out Confio Ignite (blog entry, Charlie Arehart, 2008)
MS Access-specific DB Troubleshooting Resources
- Access on 64bit ColdFusion? Yes we Can!! (blog entry, Mark Kruger, 2010)
Related Wiki Pages
See also: