Viewing 8 posts - 1 through 8 (of 8 total)
So I am going step by step:
1. All my columns are varchar.
2. Created full text index on tb_Titles on Bibnumber & TiOrderByValue. no improvemnet.
3. updated statistics - no improvement.
any other...
May 27, 2008 at 5:19 pm
Thanks for the suggestions, I am going to try step by step:
All my columns are varchar. This is an application well developed by someone else few years ago. I am...
May 13, 2008 at 9:52 am
Any other suggestions please... If you need more details let me know.
Thanks,
Archana
May 12, 2008 at 4:08 pm
Is it going to cause lot of complications/ changes to be made.
I tried to create it said full text searching not enabled then I enabled it via
sp_fulltext_database @action='enable'
then tried again...
May 12, 2008 at 1:13 pm
Hi,
Thanks for helping. I tried to create that index but as the titles are lengthy & max is 1109 & it says max length allowed is 900 bytes.......I get...
May 12, 2008 at 12:36 pm
here is the execution plan in attachment
May 12, 2008 at 11:30 am
Let me know what else should I put here to make you understand better
One example of the query I am using on the view is:
select BibNumber from [vw_TypesOnlinePeriodicalsJoin]
where TiQueryValue like...
May 12, 2008 at 10:58 am
I have a database whose size increased from like 28000 records to 800K records ansd searching in this database takes about 18 seconds which is not a pleasure, can anyone...
May 9, 2008 at 4:14 pm
Viewing 8 posts - 1 through 8 (of 8 total)