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 ...

I have a SQL server that only recently started failing with timeout exceptions. It is an older box and we are using it for more and more things. Before I write it off as a hardware/perf issue, I ...

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 ...

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 ...

This week we will discuss one of the most common error messages we get while we install the SQL version of Windows. This is the third article of the SQL ...

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 ...