Re: [SPAM] Re: [SPAM] Re: Problem with MS SQL Server 2005

2007-11-08 Thread Beketov Danila
Of Joe D'Souza Sent: Thursday, November 08, 2007 7:37 PM To: arslist@ARSLIST.ORG Subject: [SPAM] Re: [SPAM] Re: Problem with MS SQL Server 2005 What's your join criteria? Try removing that criteria, SAVE the join, then put the criteria back again and SAVE it again.. Maybe for some reason your join

Re: [SPAM] Re: Problem with MS SQL Server 2005

2007-11-08 Thread Joe D'Souza
perform a search? Joe D'Souza -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Beketov Danila Sent: Thursday, November 08, 2007 11:28 AM To: arslist@ARSLIST.ORG Subject: Re: [SPAM] Re: Problem with MS SQL Server 2005

Re: [SPAM] Re: Problem with MS SQL Server 2005

2007-11-08 Thread Beketov Danila
: Problem with MS SQL Server 2005 Let me guess.. large tables in the join, unindexed join criteria? Resulting in a table scan - it will eventually show the results if you do not press Stop, but your solution is check the join criteria and make sure that the fields in that criteria are indexed from

Re: [SPAM] Re: Problem with MS SQL Server 2005

2007-11-08 Thread Beketov Danila
Sent: Friday, November 09, 2007 12:42 AM To: arslist@ARSLIST.ORG Subject: [SPAM] Re: Problem with MS SQL Server 2005 Have you seen what is the query it runs against the database? Run an SQL log and see what you get.. Joe D'Souza -Original Message- From: Action

Re: [SPAM] Re: Problem with MS SQL Server 2005

2007-11-08 Thread Joe D'Souza
a peep. Cheers Joe D'Souza -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Beketov Danila Sent: Friday, November 09, 2007 1:21 AM To: arslist@ARSLIST.ORG Subject: Re: [SPAM] Re: Problem with MS SQL Server 2005