Dell Claims Best Hardware AwardCommented on: 9 years ago
(September 7, 2004)
I bought my first Dell in 1989 back when the company was hungry and quality was high. Though Dell had been our default hardware vendor at the company where I am the IT Director, high failure rates,...
Pivot (or Unpivot) Your DataCommented on: 9 years ago
(July 31, 2004)
The question this article highlights is, given the the all too common need to pivot data, how is it possible that this feature was left out of SQL Server 2000 in the first place, given that other '...
Recently, I've been working with a consulting client to help them tame CPU usage. Typically, they're clocking over 20,000 queries and operations per second on their e-commerce SQL Server, but ran into an issue where CPU started spiking up above 90 percent for sustained periods of time....More
What should most database administrators be doing on a regular basis? Here's a comprehensive list from Michael K. Campbell of many of the things DBAs typically do on a daily, weekly, monthly, and yearly basis....More