In all 3 cases, the database is doing a clustered index scan on the StdSchBasicData table. Usually this means that it is reading the entire table,...
plextoR, Could you give us the datatype of the schYearID column in both the UniqStdSchBasicData table and the scholasticyear table? There could be...
I think what we're really looking for here is a way to pass an array to a stored proc, which SQL Server doesn't support. The closest thing to arrays...
This might be a little late, but... I haven't worked much with distributed queries, but would it work to create the query as a view on the remote...
When I saw this topic, the first thing that popped into my mind was the Scans event classes in Profiler. I'm surprised no one responded to ghemant's...
Hello again,<br /><br />This topic is around just in case there is a solution to Part 1. If you haven't read Part 1, I'm basically at a dead-end...
Greetings folks,<br /><br />I'm working on some reports for a project and I've run into a performance wall. The reporting aspect of this project...
The couple times I've run into "insufficient memory" errors were when the result set was huge (as in many wide rows). Do you have a way to run this...
Also, in my experience with updating large tables on a regular basis, you would want to add a WHERE condition so that you are not updating rows that...
If this is all in a stored procedure and you want to keep it simple and easily maintainable, you could do conditional execution of separate select...
Hello again, I hope everyone had a great Christmas. Thank goodness for vacation time! Well, it looks like the short answer to my original question...
I am getting the expected results returned. However, I am not getting them back in the expected amount of time. The execution plan is not seeking...
The "AND" logical operator has higher precedence than "OR", which makes the following two conditions equivalent: WHERE Column1 = @SearchValue AND...
Whoops, I was in a hurry when I posted and forgot to put that part in, but yes, the actual SELECT statement does have the ORDER BY clause included (...
I have a database table set up with a composite index on 2 fields. The first field is a data field that is being searched, and the second is a...
I re-ran the stored procedure again, this time with the index pre-defined, and it still ran longer than expected. When I looked at the query plan...
I updated the statistics on TableB (I can't remember if I used 25% or 50%), which took about 45 minutes. At this point the estimated row count went...
It finally finished! It looks like the slowness may have been due to a statistics problem. When I finally got to see the actual execution plan, the...
163 hours and still going. The log file is still 18GB in size, but now 57% in use. (It was 30% at 70 hours, so the active part of the log file has...
Whew! Thank goodness for cut and paste. By the way, is there any way to indent in these forums? Following is the entire text of the stored...
Separate names with a comma.
