Viewing 7 posts - 1 through 7 (of 7 total)
Thanks that works.
September 16, 2015 at 2:40 am
#1826998
As per ours DBA instruction's we were told to use NOLOCk on the query.
Is there any problem when we give NOLOCK in the View.
December 19, 2008 at 8:56 am
#915384
Thanks Chris.
December 18, 2008 at 8:14 am
#914580
That is the whole query. You are right it hits the performance. can you give some idea to write in the condition instead as a case statement.
December 18, 2008 at 7:51 am
#914555
Instead of a table variable.If i create a permanent table will it increase the perfomance here. May be I can clear the peramanent table after the end of the...
December 8, 2008 at 6:56 am
#909122
is it possible to redirect it to different drive(d:drive) rather than c -drive ?
October 25, 2008 at 12:44 pm
#889666
Thanks Jack,
October 24, 2008 at 8:41 am
#889269