Taking the time to tune your SQL server can deliver big performance improvements and bring with it a whole flood of other benefits that make it entirely worthwhile. Here are words of wisdom from an ...
OCZ Technology has started offering to beta testers is ZD-XL SQL Accelerator, a card that uses solid state drive (SSD) storage to improve the performance of SQL Server databases. For OCZ, the ZD-XL ...
Keeping statistics up to date is vital to database performance important. Stale statistics can result in queries taking much longer to run. Here's a utility that will update the statistics in an ...
Thomas LaRock: "Without a basic understanding of wait events and how the occur, you will waste a lot of time trying and guessing at how to improve the performance of a query." Optimizing SQL Server ...
Microsoft confirms recent Windows updates cause SQL Server performance and stability issues. An emergency fix is coming.