database optimization
Some of MySQL Key area of performance tuning
6 general issues to consider when optimizing the performance of mySQL
SQL Server Triggers
Triggers are stored procedures which are fired when data is modified in an underlying table. They can evaluate data being added to a table for validation purposes, or can make changes in that or other fields depending on the value of that data. You can use them even to execute a separate stored procedure, or to roll back a data modification or an entire transaction.
A Look at SQL Server 2008 Change Tracking
Before SQL Server 2008, you had to build a custom solution if you wanted to keep track of the changes to the data in your tables. SQL Server 2008 has a new offering called Change Tracking that keeps track of each DML event type and the keys of the row that was affected.
SQL Server Fragmentation Demystified
What is SQL Server defragmentation? How does it happen? How can it be measured? How can it be minimized? How can it be fixed? Is it important?
The answers to these questions are no mystery. Depending on the version of SQL Server in use, the procedures to determine and correct defragmentation are not terribly complicated and in newer versions downright simple. In addition, they can be accomplished without unnecessary disruption of the system.
'No More Room in Index File - MySQL Error and Recovery
Stellar Phoenix Database Recovery For MySQL is the premier MySQL Recovery tool. The software supports MySQL 5.x. The tool facilitates complete recovery of InnoDB (.ibdata, .ibd and .frm) and MyISAM (.myd, .myi and .frm) files. It can recover MySQL databases created on Windows as well as Linux platforms. The software is made for the Windows platform (Windows Vista, XP, 2003 and 2000).
| Related News: |
