Recent content by BlakeK

Catadmin, Our current setup is a Windows 2003 Server Standard, running SQL 2000 Standard SP3, on a machine with 2 Xeon 3.0GHz processors, and 4 GB of RAM (SQL Standard unfortunately only uses 2GB of the RAM, so I can't wait for SQL 2005 Standard which doesn't have RAM limits!)

Denny, The WITH(NOLOCK) hint worked perfectly! And it even worked through Access, as I built the SQL and passed it to the server. That alleviated the current problem with the blocking that was occuring. I think I will still look to make it a stored procedure on the server and call that from...

Thanks for the great detail Denny. My only question is about TempDB. You mentioned that it is written to all the time, and that ideally it would be on it's on RAID array. Then you said if that's not possible, it can stay on the same array as the MDFs. If I am able to get a 3rd array for the...

Catadmin, Thanks for the info on the system databases. If I able able to have a 3rd array installed on the server, I will onlt move the LDFs for the user databases to that array. Not sure how familiar anyone here is with the hardware aspect of this situation, but will the speed benefit of having...

Denny, Thanks for the information. The query is running through an MS Access front end, so I'm not sure what options I'll be able to use. I may be able to do a pass through query and use the WIHT (NOLOCK) option you mentioned. I don't think I'll be able to anything with setting isolation...

Catadmin, I am running SQL 2000 Standard SP3. As for your comment: "The next time this happens, open up Enterprise Manager and navigate to Management -> Current Activity -> Locks / Process ID and Locks / Object. By clicking on the items listed under these two headers, it will show what process...

One note: If you look at the other post I linked to and happen to notice that there are only two tables in that query, and then look at the screen shot and see there are several tables, that is because the query I posted was a "dumbed down" version just to post here only showing the parts that...

Catadmin, thanks for the reply. We have a new set of disks that are scheduled to added to the E: drive, our data partition, because as you see, we are down to 10GB free. I am going to see if rather than adding it to the E: drive, we can create a new RAID array F: and then move all the LDFs to...

I have a query that takes 5 minutes to run. I already posted a question about ideas on improving the speed here: http://www.tek-tips.com/threadminder.cfm?pid=962 But, my new problem is that it appears that whenever a user runs this query, it is preventing other users from inserting new rows...

Right now, our SQL server machine is setup as follows: C: is 2 drives setup in a RAID 1 configuration, 33GB in size, 25 GB free D: is 4 drives setup in a RAID 5 configuration, 203 GB in size, 49 GB free E: is 6 drives setup in a RAID 5 configuration, 101 GB in size, 10 GB free Currently, SQL...

Karl, That JOIN is necessary because the field content_id in tbl_server_logs contain values that link to 3 different possible tables. There is a table tbl_advertisement, a table tbl_entertainment, and a table tbl_images which all contain the field content_id. The content_id in tbl_server_logs...

Karl, That is how I originally had it structured (without an INNER JOIN)... SELECT tbl_server_logs.server_id, Count(tbl_server_logs.content_id) AS Total FROM tbl_server_logs, tbl_advertisement WHERE tbl_advertisement.content_id = tbl_server_logs.content_id AND tbl_server_logs.zone_id = 1 AND...

I tried the query using the INNER JOIN and not using the BETWEEN... SELECT server_install_id, COUNT(tbl_server_logs.content_id) AS Total FROM tbl_server_logs INNER JOIN tbl_advertisement ON tbl_advertisement.content_id = tbl_server_logs.content_id WHERE tbl_server_logs.zone_id =...

FYI, modified query finally return after 14 minutes and 29 seconds.

donutman, That is a typo. :o DOH! (But just here on this topic, the query I am running is right. I should have cut and pasted instead of typing it!) The field in the SELECT should be server_install_id, the saem as the GROUP BY field. I changed the query as bob120579 suggested to use a JOIN and...