Weight Of Evidence

Aug 8, 2007



Hi all,

Does this paramater/metric exist in any of the DM Models in AS2005?

Thanks in advance.

Mark

View 3 Replies


ADVERTISEMENT

Conclusive Fragmentation Evidence Required

Sep 5, 2007

Currently managing a VLDB which is heavily fragmented. The applications characteristics are heavy INSERTS, UPDATES and DELETES and against my recommendations the majority of the large tables are HEAPS or have inadequate non-clustered indexes. The code is dynamic SQL, the tables dynamic and the vendor's understanding of SQL is poor which hampers my progress here.

Both the OS defrag GUI and sys.dm_db_index_physical_stats show huge amounts of fragmentation, some tables are around 80%. Note: (Indexreorg jobs are in place where indexes are present)

The problem I have is convincing the windows engineers whom contol the budget that deploying a defrag tool such as Idera's Defrag Manager will actually be of any use. They keep asking whether the app will actually will get inside the DB and I'm curious whether there will be any benefit on the HEAP tables should the vendor not make changes to their code.

Is there any conclusive evidence I can provide these Window guys to quantify my defrag expenditure request? Any help would be appreciated

View 15 Replies View Related

Weight Term From Contains

Jan 26, 2008

what use  reason  of 'weighted-term' ?explain it.
SELECT     ID, firstname, lastnameFROM         [contain-1]WHERE     CONTAINS(firstname, 'ISABOUT(mohsen weight(.8),yaser weight(1.0))')
table [contain-1] information:
ID     FIRSTNAME
1        mohsen
2       mohsen
3       yaser
4      mehdi
 
thanks,mohsen

View 1 Replies View Related

How To Sum The Weight Of The Column?

Jan 11, 2008

HI

The below is the asp code pasted here to explain what I am trying to do. How to Sum the weight of the item group by itemcode which is passed as a parameter


Do While Not objRS.EOF

itmcode = objRS("SKU")

sSQL = "SELECT code, numpacks, weight FROM tblproducts WHERE code = '" & itmcode & "'"
Set rsNumpks = Conn.Execute(sSQL)
If Not rsNumpks.EOF Then
numpacks = CDbl(rsNumpks("Numpacks"))
weigh = CDbl(rsNumpks("Weight"))
End If
Set rsNumpks = Nothing
Loop

View 4 Replies View Related

Analysis :: Any Way To Retrieve Weight % Of Some Values?

Apr 6, 2015

Is there any way to retrieve the weight % of some values?

A quick example:
A 10 -> Result i want is 10 / 60 (60 is the SUM of A,B and C)
B 20 -> 20 /60
C 30 -> 30/60
Code for number of subscriptions
EVALUATE
SUMMARIZE('Subscriptions',
          'Subscriptions Type'[DS_SUBS_TYPE],
"Number of Subscriptions ",'Subscriptions'[NR_SUBSCRIPTIONS]).

View 4 Replies View Related

RS 2000 Font Weight Expression?

Sep 24, 2007

Is it possible to dynamically set the font weight (bold vs normal) for a matrix row label? I always get an invalid value message box from the expression editor. For example:

IIf(Inscope("matrix1_Label_Name"),IIf(First(Fields!Label_Bold.Value,"matrix1_Label_Name") = "y"),"Bold","Normal"),"Normal")

Something like the following:

label1 | xxx xxx xxx
label2 | xxx xxx xxx
label3 | xxx xxx xxx
label4 | xxx xxx xxx

Thanks

View 1 Replies View Related

Dynamically Set Different Font Weight For Each Text In The Textbox

Aug 6, 2007

Hi friends,

I have a text box with n number of text.
I want to set the font weight of each text in the textbox dynamically..

For eg.. suppose the text of the textbox is "Hello Friends", then i need "Hello Friends" as output.

Is there any way to accomplish this in SQL Reporting Service.

Any help will be appreciated. Its critical.

Please help me out ASAP.

View 8 Replies View Related

Full Text Search And CONTAINSTABLE - Can I Weight By Column?

Aug 8, 2006

I'm trying to use CONTAINSTABLE to do a product search on a number of columns. I want matches on some columns to be weighted higher than for other columns.

It seems like there should be a way to do this with CONTAINSTABLE - I know I can search by multiple strings and weight those matches variably, but what I want is to vary the weight by which column a single term matched. What I have now is a series of UNION queries, which are quite slow:
===================
SELECT m.TitleCode, m.ShortName, m.ShortDescription, a.Rank, 50 as theWeight
FROM CONTAINSTABLE (Product, ShortName, @theSearchTerm) as a, Product m(NoLock)
WHERE a.[KEY] = m.TitleCode

UNION ALL

SELECT m.TitleCode, m.ShortName, m.ShortDescription, a.Rank, 40 as theWeight
FROM FREETEXTTABLE (Product, ShortName, @theSearchTerm) as a, Product m(NoLock)
WHERE a.[KEY] = m.TitleCode

UNION ALL

SELECT m.TitleCode, m.ShortName, m.ShortDescription, a.Rank, 30 as theWeight
FROM FREETEXTTABLE (Product, MatchKeywords, @theSearchTerm) as a, Product m(NoLock)
WHERE a.[KEY] = m.TitleCode

UNION ALL

SELECT m.TitleCode, m.ShortName, m.ShortDescription, a.Rank, 20 as theWeight
FROM FREETEXTTABLE (Product, ShortDescription, @theSearchTerm) as a, Product m(NoLock)
WHERE a.[KEY] = m.TitleCode

ORDER BY 'theWeight' DESC, m.ShortName

===================

What is the better way?

View 1 Replies View Related

FULLTEXT CONTAINSTABLE ISABOUT WEIGHT ?? SYNTAX Ranking Search

Mar 25, 2008



Sorry, is this possible?


select * from COLLABORATOR x inner join

containstable

(CollaborAtor,*,

' ISABOUT (

"hiv and Gender" weight (.8)

or

"hiv or Gender" weight (.2)

)

'

)

as KEY_TBL

on x.ColId = KEY_TBL.[KEY]



==

basically I want all rows with either string, but I want those with both to rank first.

Also, how can I deal with singular vs plurals of words..

Thanks.

View 1 Replies View Related

Can I Ask How To Use 'weight' Variable In Descision Tree And How To Use Cross Validation In The Data Mining Procedure?

Jun 15, 2007

Also when using cross validation, which descision tree should we choose?



Thanks very much

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved