Viewing 15 posts - 12,286 through 12,300 (of 22,214 total)
Cost is an estimate generated by the optimizer. You can't control except by making the plan simpler.
As to why the query would run faster because you removed quotes, I have...
June 15, 2011 at 11:26 am
ALZDBA (6/15/2011)
Grant Fritchey (6/15/2011)
That's 10,000 posts, done.Wait, now it's 10,001.
Congratulations, Grant.
Apparently you have been very active today, now you're already at :
Points: 10,881, Visits: 21,283
Nah, that's points. I was...
June 15, 2011 at 7:06 am
GilaMonster (6/15/2011)
Grant Fritchey (6/15/2011)
June 15, 2011 at 7:04 am
You could create a hash column as a calculated column next to your varchar(max) and then put a unique constraint on the hash column. It's unlikely to be perfect, but...
June 15, 2011 at 5:58 am
That's 10,000 posts, done.
Wait, now it's 10,001.
June 15, 2011 at 5:49 am
In a perfect world, 15% is probably workable, but with unexpected data loads, badly performing apps, failed maintenance jobs, sunspots, alien invasion... I prefer to run 30% free, minimum, unless...
June 15, 2011 at 5:30 am
If a query is executing, it has an execution plan. The plan comes first. And it gets stored in the plan cache prior to execution as well. If that process...
June 15, 2011 at 5:26 am
Looks like parallelism might be getting you. The cost for the plan is only 3. What is your cost threshold for parallelism? Default should be 5. Try setting it up...
June 15, 2011 at 4:58 am
Instead of checking the error log every two hours, why don't you just have the errors forwarded to you directly. Then you know about them when they happened rather than...
June 15, 2011 at 4:51 am
The thing is, it's likely to reduce deadlocks, but it's unlikely to eliminate them and it certainly won't prevent them in the future. Best way to avoid or fix deadlocks...
June 14, 2011 at 4:07 pm
Stefan Krzywicki (6/14/2011)
Grant Fritchey (6/14/2011)
June 14, 2011 at 12:31 pm
Perfmon is extremely lightweight if you're capturing the data out to a file other than the OS drive or on of the data or log drives for the database. If...
June 14, 2011 at 12:03 pm
Oh yes, there's a whole elite level of forums where we actually post only real answers instead of the usual pile of... oh my god... ninjas... arggghhhh!!!!
Nothing to see here....
June 14, 2011 at 10:39 am
I wouldn't get too hung on trying to correlate the two, but the events are showing pages read. A 1 is one page. 2, etc. are more pages. I don't...
June 14, 2011 at 10:37 am
Profiler is for viewing the results of and defining server side traces. You can also run it directly against a database to capture data, but I don't recommend it.
It's primary...
June 14, 2011 at 10:27 am
Viewing 15 posts - 12,286 through 12,300 (of 22,214 total)