Monthly Archives: September 2011

Missing indexes = poor performance

Install the following procedure in your usual database admin folder and run it occasionally to see where new indexes would benefit your queries. Don’t install all the indexes it suggests. Some will be huge and pointless as they will have … Continue reading

Posted in Developer stuff, SQL Stuff | Tagged , , , , , , | Leave a comment

Troubleshooting: string or binary data would be truncated

Image you have an INSERT INTO query that takes a long time to run that has multiple joins and complexities where many of the columns are string types and one of these is presenting an error. The select statement takes … Continue reading

Posted in Developer stuff, SQL Stuff | Tagged , | 2 Comments