all groups > sql server data mining > july 2005
SQL statment help
Posted by FelixLeung at 7/28/2005 7:36:38 PM
Dear all,
How can I get only 1 row at a time without using where x=unique condition?
Thanks
Felix
... more >>
Stored Procs vs VIEWS: Seeking Comparison
Posted by Joseph Geretz at 7/28/2005 1:53:16 PM
Every article which I've seen proposing Stored Procedures makes the same
comparison: Stored Procs are faster than submitted SQL because Stored Procs
are precompiled. Fine, but there's a third alternative, which I haven't seen
mentioned at all. How do Stored Procedures compare with VIEWS?
No... more >>
Need some suggestion on a web mining tool
Posted by BA at 7/16/2005 11:53:49 AM
Hello,
I would appreciate any comments on some web mining tools. I am aware of
Velocityscape. Their tool is nice, but over priced.
Thanks in advance.
Brian.
... more >>
query that compares tables
Posted by J at 7/14/2005 1:15:05 PM
I’m trying to find orphaned records that resulted when a new table was
created to normalize data but unnecessary records were added in the process.
I have 2 related tables, let's call them tblA and tblB, that I need to
compare.
I need to first know where tblA.Name = tblB.Name then from that... more >>
Following Siblings
Posted by Tim Chapla at 7/14/2005 8:24:08 AM
Can anyone offer some advice on creating a calculated member representing
the sum of 'Following Siblings' of a measure, based on the current member of
a dimension?
I am trying to accomplish this with the following statement to no avail.
member [Measures].[CalcMeasure] as 'Sum(Filter({[Meas... more >>
SQL Server Data Archival
Posted by Saurabh at 7/13/2005 3:05:06 AM
Hi,
I need some clarifications on some of the questions mentioned below with
regards to Data archiving optimized approach (Performance considerations)in
case of SQL Server. If you have the right answers please do provide.
Questions: -
1. Should the achieved data (in the form of tables) b... more >>
example of association analysis with sql server 2000
Posted by Julien at 7/5/2005 4:35:03 AM
hello !
i'm looking for an example of association analysis to use with sql server AS
2000
i found this link :
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnduwon/html/d52design.asp
(from this thread :
http://groups.google.com/groups?hl=fr&lr=&th=4e8e8574c8901edf&rnum=1... more >>
|