Data Mining

Are the Data Mining capabilities in Excel only available with Excel 2007?

How does one implement the data mining in Excel 2007?

The recently published Data Mining add-ins for Office only work with Office 2007.

> How does one implement the data mining in Excel 2007?
I am not sure I understand the question. Are you interested in implementing your own add-ins for Excel? Or in using the existing add-ins?

|||

The SQL Server Data Mining Add-Ins for Office 2007 work only with Office 2007 - notably Excel 2007 and Visio 2007.

To implement an Excel 2007 Data Mining solution, you first need Excel 2007 and SQL Server 2005 Analysis Services. Analysis Services is included with SQL Server 2005 Standard and Enterprise Editions and is an installation option. Finally you need the add-ins package itself, which is available as a free download from here: http://www.microsoft.com/sql/technologies/dm/addins.mspx

If you currently do not have licenses for Office 2007 and/or SQL Server 2005, this link (http://www.sqlserverdatamining.com/DMCommunity/TipsNTricks/4429.aspx) provides a guide on how to try out the data mining addins using evaluation editions of Office 2007 and SQL Server 2005.

Data Mining

Are the Data Mining capabilities in Excel only available with Excel 2007?

How does one implement the data mining in Excel 2007?

The recently published Data Mining add-ins for Office only work with Office 2007.

> How does one implement the data mining in Excel 2007?
I am not sure I understand the question. Are you interested in implementing your own add-ins for Excel? Or in using the existing add-ins?

|||

The SQL Server Data Mining Add-Ins for Office 2007 work only with Office 2007 - notably Excel 2007 and Visio 2007.

To implement an Excel 2007 Data Mining solution, you first need Excel 2007 and SQL Server 2005 Analysis Services. Analysis Services is included with SQL Server 2005 Standard and Enterprise Editions and is an installation option. Finally you need the add-ins package itself, which is available as a free download from here: http://www.microsoft.com/sql/technologies/dm/addins.mspx

If you currently do not have licenses for Office 2007 and/or SQL Server 2005, this link (http://www.sqlserverdatamining.com/DMCommunity/TipsNTricks/4429.aspx) provides a guide on how to try out the data mining addins using evaluation editions of Office 2007 and SQL Server 2005.

Data handling capabilities of SQL Server 2000 Enterprise Edition

I am developing an intranet portal on Microsoft .NET platform and using
SQL Server 2000 Enterprise Edition as the database.
I would like to know the maximum size to which the database can grow to
in SQL Server as many tables in the database will have over 1 million
records with each row having images, documents stored in it.
The server housing SQL Server is Dell PowerEdge 2950 with single CPU
dual Core Xeon 4MB Cache 3.0Ghz, 2GB memory, 73GB disk space and RAID 5.In reality the size of the database is limited by your disk space.
According to BOL the database size can be up to 1,048,516 TB (depending
on the edition that you have). If you meant to ask at what size the
database's performance will not be good, then that depends on the
database's structure, the quality of the code that works with the
database, the number of concurrent users and other factors much more
then it depends on the database's size.
Adi
ram2811 wrote:
> I am developing an intranet portal on Microsoft .NET platform and using
> SQL Server 2000 Enterprise Edition as the database.
> I would like to know the maximum size to which the database can grow to
> in SQL Server as many tables in the database will have over 1 million
> records with each row having images, documents stored in it.
> The server housing SQL Server is Dell PowerEdge 2950 with single CPU
> dual Core Xeon 4MB Cache 3.0Ghz, 2GB memory, 73GB disk space and RAID 5.|||"ram2811" <ram2811@.gmail.com> wrote in message
news:1163533063.339418.203140@.i42g2000cwa.googlegroups.com...
>I am developing an intranet portal on Microsoft .NET platform and using
> SQL Server 2000 Enterprise Edition as the database.
> I would like to know the maximum size to which the database can grow to
> in SQL Server as many tables in the database will have over 1 million
> records with each row having images, documents stored in it.
> The server housing SQL Server is Dell PowerEdge 2950 with single CPU
> dual Core Xeon 4MB Cache 3.0Ghz, 2GB memory, 73GB disk space and RAID 5.
In this case it sounds like the max size will be 73 GB.
I'd suggest NOT storing images in the database, but that's a different
debate.
btw, 1 million records is generally considered, "small" these days.
>|||thanks for the reply
Adi wrote:
> In reality the size of the database is limited by your disk space.
> According to BOL the database size can be up to 1,048,516 TB (depending
> on the edition that you have). If you meant to ask at what size the
> database's performance will not be good, then that depends on the
> database's structure, the quality of the code that works with the
> database, the number of concurrent users and other factors much more
> then it depends on the database's size.
> Adi
> ram2811 wrote:
> > I am developing an intranet portal on Microsoft .NET platform and using
> > SQL Server 2000 Enterprise Edition as the database.
> > I would like to know the maximum size to which the database can grow to
> > in SQL Server as many tables in the database will have over 1 million
> > records with each row having images, documents stored in it.
> > The server housing SQL Server is Dell PowerEdge 2950 with single CPU
> > dual Core Xeon 4MB Cache 3.0Ghz, 2GB memory, 73GB disk space and RAID 5.

Data handling capabilities of SQL Server 2000 Enterprise Edition

I am developing an intranet portal on Microsoft .NET platform and using
SQL Server 2000 Enterprise Edition as the database.
I would like to know the maximum size to which the database can grow to
in SQL Server as many tables in the database will have over 1 million
records with each row having images, documents stored in it.
The server housing SQL Server is Dell PowerEdge 2950 with single CPU
dual Core Xeon 4MB Cache 3.0Ghz, 2GB memory, 73GB disk space and RAID 5.
In reality the size of the database is limited by your disk space.
According to BOL the database size can be up to 1,048,516 TB (depending
on the edition that you have). If you meant to ask at what size the
database's performance will not be good, then that depends on the
database's structure, the quality of the code that works with the
database, the number of concurrent users and other factors much more
then it depends on the database's size.
Adi
ram2811 wrote:
> I am developing an intranet portal on Microsoft .NET platform and using
> SQL Server 2000 Enterprise Edition as the database.
> I would like to know the maximum size to which the database can grow to
> in SQL Server as many tables in the database will have over 1 million
> records with each row having images, documents stored in it.
> The server housing SQL Server is Dell PowerEdge 2950 with single CPU
> dual Core Xeon 4MB Cache 3.0Ghz, 2GB memory, 73GB disk space and RAID 5.
|||"ram2811" <ram2811@.gmail.com> wrote in message
news:1163533063.339418.203140@.i42g2000cwa.googlegr oups.com...
>I am developing an intranet portal on Microsoft .NET platform and using
> SQL Server 2000 Enterprise Edition as the database.
> I would like to know the maximum size to which the database can grow to
> in SQL Server as many tables in the database will have over 1 million
> records with each row having images, documents stored in it.
> The server housing SQL Server is Dell PowerEdge 2950 with single CPU
> dual Core Xeon 4MB Cache 3.0Ghz, 2GB memory, 73GB disk space and RAID 5.
In this case it sounds like the max size will be 73 GB.
I'd suggest NOT storing images in the database, but that's a different
debate.
btw, 1 million records is generally considered, "small" these days.

>
|||thanks for the reply
Adi wrote:[vbcol=seagreen]
> In reality the size of the database is limited by your disk space.
> According to BOL the database size can be up to 1,048,516 TB (depending
> on the edition that you have). If you meant to ask at what size the
> database's performance will not be good, then that depends on the
> database's structure, the quality of the code that works with the
> database, the number of concurrent users and other factors much more
> then it depends on the database's size.
> Adi
> ram2811 wrote:

Data handling capabilities of SQL Server 2000 Enterprise Edition

I am developing an intranet portal on Microsoft .NET platform and using
SQL Server 2000 Enterprise Edition as the database.
I would like to know the maximum size to which the database can grow to
in SQL Server as many tables in the database will have over 1 million
records with each row having images, documents stored in it.
The server housing SQL Server is Dell PowerEdge 2950 with single CPU
dual Core Xeon 4MB Cache 3.0Ghz, 2GB memory, 73GB disk space and RAID 5.In reality the size of the database is limited by your disk space.
According to BOL the database size can be up to 1,048,516 TB (depending
on the edition that you have). If you meant to ask at what size the
database's performance will not be good, then that depends on the
database's structure, the quality of the code that works with the
database, the number of concurrent users and other factors much more
then it depends on the database's size.
Adi
ram2811 wrote:
> I am developing an intranet portal on Microsoft .NET platform and using
> SQL Server 2000 Enterprise Edition as the database.
> I would like to know the maximum size to which the database can grow to
> in SQL Server as many tables in the database will have over 1 million
> records with each row having images, documents stored in it.
> The server housing SQL Server is Dell PowerEdge 2950 with single CPU
> dual Core Xeon 4MB Cache 3.0Ghz, 2GB memory, 73GB disk space and RAID 5.|||"ram2811" <ram2811@.gmail.com> wrote in message
news:1163533063.339418.203140@.i42g2000cwa.googlegroups.com...
>I am developing an intranet portal on Microsoft .NET platform and using
> SQL Server 2000 Enterprise Edition as the database.
> I would like to know the maximum size to which the database can grow to
> in SQL Server as many tables in the database will have over 1 million
> records with each row having images, documents stored in it.
> The server housing SQL Server is Dell PowerEdge 2950 with single CPU
> dual Core Xeon 4MB Cache 3.0Ghz, 2GB memory, 73GB disk space and RAID 5.
In this case it sounds like the max size will be 73 GB.
I'd suggest NOT storing images in the database, but that's a different
debate.
btw, 1 million records is generally considered, "small" these days.

>|||thanks for the reply
Adi wrote:[vbcol=seagreen]
> In reality the size of the database is limited by your disk space.
> According to BOL the database size can be up to 1,048,516 TB (depending
> on the edition that you have). If you meant to ask at what size the
> database's performance will not be good, then that depends on the
> database's structure, the quality of the code that works with the
> database, the number of concurrent users and other factors much more
> then it depends on the database's size.
> Adi
> ram2811 wrote: