Search results for query: *

I don't understand why you sent me this link. It's a whitepaper on monitoring. I'm trying to keep the CPU from spiking when I do a file copy using the FileSystemObject in vbscript. I read through the whitepaper anyway just to make sure I wasn't missing anything, but I didn't see anything...

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

Thank you so much. My SQL inexperience shows here in that I never considered adding date conditions to the JOIN. It amazes me how obvious things are when someone shows you a solution. Again, many thanks. :)

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

Thanks! I'll give this a shot. I had already coded it with the php sort when a user selected losses in the drop-down, but it was noticably slower than the other sorts. This should speed it up considerably. I appreciate the help.

No. A Guild hall can only have one guild note, but there will be many matches associated with it.

Actually, I realized I need a LEFT OUTER JOIN instead of an INNER JOIN, but my losses problem is still the same.

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