Archived Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007


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 >>



DevelopmentNow Blog