Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
RoyalSher
Yak Posting Veteran
95 Posts |
 Posted - 2003-05-16 : 09:29:23
|
Hi,I have a stored procedure involving a Heterogeneous Query. A Linked Server is added to retrieve values from Active Directory Service.During tuning of the query and understanding the query execution plan.. I had observed a stmt "Row Count Spool". On further exploration for the cause of Row Count Spool, my observation has been inferred to a Join Problem.Can any body tell me if i am right in my inference and let me ne solution for troubleshooting the Row Count Spool as it is a temporary table reference.?Thanks in Advance. RoyalSher.*********The world is the great gymnasium where we come to make ourselves strong. |
|
|
|
|
|
Row Count Spool