CPU issues have long been the bane of database and system administrators. I have worked on enterprise databases since the mid-1980s and seen three significant eras for CPU architecture and ...

This project demonstrates a real-world database support scenario where a reporting SQL query was performing inefficiently due to missing indexes and non-optimized SQL joins. The objective of this ...

Me again. By know you guys probably figured out my strength isn't in hardware <BR><BR>Anyway.....<BR><BR>I came in Monday morning to find that our SQL server running SQL 2000 was hung. I have a ...

Hi everyone! It's great to be back on Database Trends and Applications magazine. While I dropped out of the regular columnist position for quite a while, I was still hard at it promoting strong ...