Well, I've come into the office today to check and find the log file is now (after shrinking) down to a little over 1GB. It seems as though as every...
We are a small company and happen to be the developers of all the apps here as well. When I look at all of the running processes (Management/Current...
Data recovery model is "Full". We use this setting on all of our other databases though and do not have this problem. sqladmin -- How can I tell if...
For one of my databases my log file has grown to over 8gb. There are full database backups made of this database daily, and transaction log backups...
No other ideas?
Makes sense. Thanks for the explanation. It is taking 3-5 seconds to run with the following commands preceding the query: CHECKPOINT GO DBCC...
What would be the purpose of executing "CHECKPOINT" before both DBCC commands? I looked it up and it states that it forces the writing to disk of all...
Yes, I am. I am running the following each time before I execute the query: DBCC DROPCLEANBUFFERS DBCC FREEPROCCACHE
quote:Originally posted by mmarovic quote:Both queries seem to execute in about the same amount of times, approx. 2 seconds. This means we have...
quote:Originally posted by Adriaan Since you are gathering aggregates, why not run separate queries to get the different counts? You could just do a...
When I take out both DISTINCTS I am able to get the query down to 1 second. So we're definitely making progress, but the problem is that I need this...
mmarovic,<br /><br />I have done as you have suggested. Had to tweak the query a bit and fix a few typos, but here it is:<br /><br /><pre...
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by...
Ok, all. I have replaced COALESCE with COUNT as suggested, and unfortunately there is no noticeable difference.<br /><br />Here is an update of what...
mmavoric, I sincerely appreciate your time and help. As for the images in each category, some categories have as few as 50 images, while others have...
mmarovic,<br /><br />Ok. I did misunderstand. After making tblImages.cat_id the ONLY field in the clustered index, and take out the join on tblSets I...
mmarovic,<br /><br />tblImage.cat_id is already in the clustered index, and is the first field in this index.<br /><br />joechang,<br /><br />I have...
Ok. Just did what you suggested and it now takes 4 seconds consistently. When I put the indexes back to the way they were, it takes between 3 and 4...
The query below is taking 3-4 seconds to run under a light load, which seems to be a bit lengthy for the indexes that are in place and the amount of...
Separate names with a comma.
