Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Controlling CPU Usage?
I currently have a vbscript that runs nightly to compress logs (with bzip2) and move them from one drive to another with more space. This runs on twenty servers every night at about 2:00 am. Each of these servers is monitored in Microsoft Operations Manager. Recently, the size of log files... -
Limit HAVING without limiting SELECT
Setup: I have three tables that I am joining to display some simple statistics. The query I have no is working great, but I need to limit the aggregate functions by date. The first table is ghall, which has some information about ghall objects. There are eight records in the table and it... -
Please help convert a subselect to inner join
I was developing a php/postuke app for a client and I wrote two of my SQL queries with subselects. I found out after I was done that they were pretty much stuck with MySQL 4.0.x for awhile, so I need to revamp my queries to avoid subselects. The query uses three tables: nuke_gwbt_guild_halls...
