Solid state hard drives or SSD's as they are also known are the latest generation of hard disk storage. They are far superior to traditional hard disk drives because of the absence of moving parts and so are blisteringly faster in comparison. Due to the architecture of the platter based hard disk, it is much slower than other parts of the server and can typically be the … [Read more...] about Will solid state hard drives negate the need to performance tune your database server?
The following tips do not promise that your database server will magically become blisteringly fast and go like a Ferrari but they are important things to bear in mind and relatively simple to implement either when building your database or if you have an existing performance problem and are looking for ways in which to make your database run faster. 1/ SELECT * FROM The rest … [Read more...] about 10 simple tips on improving query and server performance