Hello all. (I'm not sure that my message is convinient for this forum, but i don't know where else …
17 years, 8 months ago
By: David Benoit
How do I clear the procedure cache?
dbcc freeproccache (undocumented) - Removes all elements from t…
By: Steve Jones - SSC Editor
Have just started doing some performance monitoring using the profiler tool. Each time a sp is call…
My processors on one server are avg 85+ utilization. I am in the process of trouble shooting this t…
I'm trying to find any information about SQLSERVER 6.5 running on an Octoprocessor.
It seems that t…
We are on SS2K. In errorlog we are gettinig
"This SQL Server has been optimized for 8 concurrent qu…
Has anyone used pintable before? what was
Just finished working out a problem (well, probably not a problem as such) with views.
By: Andy Warren
Ive spent some time buggering around with profiler under ss2k EE. Basically
I only want to …
Prior to version 7 you could specify that tempdb resides in ram. This feature has been taken away …
I'm trying to keep a full text catalog constantly updated using change_tracking, and background_upd…
Don't know if I am missing something. I have just returned from a training class on optimizing SQL…
17 years, 9 months ago
Simply put, what are the benefits of doing one over the other.
I favor updating statistics, but I h…
By: Tom Goltl
Sql server 7.0
How to shrink database and truncate log on checkpoint from a job which will run at n…
By: Paul Ibison
I am getting the error message in the subject intermittantly. I was wondering if anyone else has s…
Viewing 15 topics - 2,551 through 2,565 (of 2,578 total)
You must be logged in to create new topics.