Forum Replies Created

Viewing 15 posts - 1 through 15 (of 44 total)

  • RE: LIKE operator with millions of records giving slow performance

    Hi Chris,

    Right now i want to keep this idea as the last option.currently i am seeing if full text index works for me .. Any suggestion how can i accomplish...

  • RE: LIKE operator with millions of records giving slow performance

    I dont have any rules in between .. It was as similar to URLName like URLExclusionName( because the URLExclusionName already starts with % and ends with %). There was nothing...

  • RE: FTS CONTAINS vs. %LIKE%

    Thinking of the same requirement.,i am using URLS to search so my base URL will be something like http:\\www.google.com . I have another table which contains the keywords or like...

  • RE: LIKE operator with millions of records giving slow performance

    Here is the sample data

    %://llnw-1083.listen.com/6%.rad%

    %://fe5357.sidestep.com/servlet6/%

    %://cdn-62.blinkx.com/stream/%.flv%

    %://genio.virgilio.it/scripts/alice/ifr_virg_comu_genio_cachebust.js_728x90_rmt931648.html%

    %://download462.mediafire.com%

    %://www.asus.com.au/websites/au/xml/localization.xml%

    %://msnvideoar.vo.llnwd.net/d1/stupidvideos/dog_taps_paw_in_time.flv%

    %://www.princes-trust.org.uk/crossdomain.xml%

    %://www.shockwave.com/content/sol_addiction/sis/addict.dat%

    %://quality-s.qvc.comquality-s.qvc.com%

    I understand the URLName starts with % and indexes wont work when it finds %. thus why i am thinking to use FullText Indexes but not...

  • RE: LIKE operator with millions of records giving slow performance

    Hi Eugine,

    Yes,they are URL Names .i cant seggregate them with some criteria.. What i was thinking among these three approaches

    1) First use Exists clause and update the ExclusionID with 0...

  • RE: LIKE operator with millions of records giving slow performance

    Hi Chris,

    Nice to hear from you.. I am have gone through couple of articles posted by you. This requirement is unavoidable to use like operator. Finally i got ready to...

  • RE: LIKE operator with millions of records giving slow performance

    There are 5 million records in person table and 4 million in person exclude table

    We are trying in different ways but couldn't find a convincing solution. please suggest what can...

  • RE: LIKE operator with millions of records giving slow performance

    (On behalf of santosh)

    Hi

    We understand the join from left side is returning more records. so we have a slight change in our requirement to return first record matched

    Supppose in above...

  • RE: Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts

    Hi,

    I want to use this SCOM. i just want to know where can i find it .where is this application residing in vista. do i need to install it

    Thanks

    Raj Deep.A

  • RE: Conditional Help

    I Understand your requirement,Can you please send me the sample matrix you are showing now.

    As i understood,you dont want to disturb the present matrix,but you want to add another columns...

  • RE: Need Consecutive Query

    It Works.Thank you very much David

    Regards

    Raj Deep.A

  • RE: Problem in SubTotal

    Actually,

    I typed the matrix manually to show the matrix.there is no problem ,i am able to see the values if they are null and Zero.It was Ok as i...

  • RE: report with matrix

    Hi ,

    I Understand your posting but i need some more information to solve your problem

    This Scenario is enough for how the report should look like But it is not enough...

  • RE: Need to calculate %

    Hey,

    Try this

    =IIF(Fields!Sales.Value0,Fields!Margin.Value)/ IIF(Max(Fields!Sales.Value)=0,1,Max(Fields!Sales.Value))," ")

    Regards

    Raj Deep.A

  • RE: entering multiple Id''''s in a parameter

    Actually it the multiple parametres in Sql Server 2005.Instead try to create some procedure like this in Database

    CREATE FUNCTION dbo.Split

    (

    @ItemList NVARCHAR(4000),

    @delimiter CHAR(1)

    )

    RETURNS @IDTable TABLE (Item VARCHAR(50))

    AS ...

Viewing 15 posts - 1 through 15 (of 44 total)