Sql Performance

Good Articles:

http://www.devshed.com/c/a/MySQL/SQL-Performance-and-Tuning-Considerations/3/

http://www.devshed.com/c/a/MySQL/SQL-Performance-and-Tuning-Considerations/4/

This is a five part article – have a look at the others, but the rest are pretty basic. Note this is also for MySQL, so check any detail.

Linux - Delete older files

Useful for clearing out massive mail directories...

find /path/ -mtime +7 -delete

Deletes everything older than 7 days.

Useful SqlServer Information

Couple of good SQL Server DB articles:

Scaling Up Your Data Warehouse with SQL Server 2008 R2

SQL SERVER – Shrinking Database is Bad – Increases Fragmentation – Reduces Performance

SharePoint Configuration (SharePoint_Config.LDF) Log file too large

My Sharepoint_Config Log file became massive (30Gb!!!) so I spent a few hours trying to work out what to do about it and found this:

MPECS Inc. Blog: SBS BPA: Reduce The Size of The SharePoint Configuration Databases