.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links


Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
Hi  I am a newbie for data mining. As part of a project I need to categorise a set of customers of a grocery based on their age, gender, and average spending. I believe I should use the Clustering algorithm. I created a mining model a structure and a cube as well from the existing data base. But i can't get much further than that. What kind of queries should i write to "cluster" the customers and get their relevant clusters??  

View Complete Post

More Related Resource Links

Would you use clustering to find documents similar to this one?

Hi, I am taking a BI Developer course and enrolled at a school where the teacher knows nothing about data mining. So I designed a project for myself and am trying to surmount the curve without the benefit of a mentor. Please have patience with me. I have a database full of documents where the entire text resides in a single field (nvarchar(max)) I want to find documents that are similar to the one I pick. I am not sure what approach I should take to get there..         1) create clusters for the entire database and then see what cluster my document is in OR                 2) some-how train a model on the single document and then let the DM engine go find the matches.   I have tried approach 1, but the similarity between the documents is not very high (at least in the few of thousands I looked at) I do not see how to do approach 2, unless I cluster with a test set size of 1, and that doesnt seem right.   Is clustering even the way to go?   Thanks, struggling in Austin

Clustering on cube slices

Hi, I would like to use the clustering algorithm "seperately" on each cube slice.  The problem description: Having many employes and their arrival-to-work time I created a cube with a fact table and 3 dimensions: Employee, Time, Office and I would like to run the clustering algorithm seperately for each employee to receive his arrival-to-work clusters and to find his exceptions e.g., for the employee John who has the following arrival time records: 08:05, 07:55, 8:10, 8:07, 10:30, 10:31, 10:28, 15:00 I want to receive two clusters, the first one will include  08:05, 07:55, 8:10, 8:07 The second one will include 10:30, 10:31, 10:28 (and the exception will be 15:00) Having many employees I would like to create one data mining model and to use the cube slice and dice options    Searching the web and the MSDN I didn't find whether and how it can be done - I will very appreciate your help   Thanks in advance, Lora

SQL 2008 R2 Full Clustering

I was recently informed during a Microsoft Roadmap meeting that SQL2008R2 can now be fully clustered. That is full load balancing across SQL servers not just Failover. However, having come away from the meeting and done some investigation I cannot find any references as to how to setup SQL2008R2 in anything other than a failover cluster. My question is ... Is SQL 2008 R2 fully clusterable ... and if Yes where can I find some documentation helping with its setup ?   Thanks in advance Derek

20,000 foot view: Sql Server clustering vs. Windows OS Clustering

I read that Sql Server Failover requires Windows Sevrer clustering to be in place first. (The former builds on the latter). Why is this the case? In other words, what does "sql server clustering" bring to the mix  that normal Windows clustering doesn't supply? TIA, Barkingdog  

troubleshooting clustering

i need step by step for installations of clustering in sql server 2008 environment? please help me on this.

Clustering of Sql server

Hi Everybody, please answer this questions this will be very helpful to me     1. discuss at a high level how to add a new node to an existing SQL cluster in both SQL 2008 and SQL 2005. Begin with SQL 2005.   2. You are a DBA.  The SAN Admin has provisioned a LUN on the SAN and presented it to the nodes and made it clustered storage. At a high level, in either 2005 or 2008 walk through adding the new storage to the SQL instance and what is very important not to forget?   3. Beginning in 2005, there is a SERVERPROPERTY we can now use in T-SQL to discover which node the SQL instance is running on?     Thank you Regards rcnj

SQL clustering 2008

While going to install sql2008 in 2008 OS sp1 unable to install Error " Managed SQL Server Landing Page has stopped Working"

Getting Started -> clustering

Hello All,   We currently have the following:   SERVER A2000 with SQL Server 2000 SERVER B2005 with SQL Server 2005 SERVER C2005 with SQL Server 2005   SERVER B2005 is our research database and currently has a growing number of survey-based applications that each has its own database {SurveySystem1, SurveySystem2, SurveySystem3, SurveySystem4, etc...} ..... each of these applications are C# .net applications.   Over time we have noticed that if one of the SurveySystem applications (for example: SurveySystem2) has a large simultaneous response (100+ participants all responding to a survey at the same time), the SurveySystem2 website application will slow down and some participants will not be able to complete the survey.   We think the problem is the SQL Server 2005 database... and that it is not able to handle that many simultaneous users.  So, we are thinking of upgrading (BOTH to 2008 AND to a clustered environment).....   QUESTION: can someone give me an overview of: (1)What we will need to move to this new environment (software + hardware); (2)Do you think this will fix the problems that the participants are experiencing, or do you think the bottleneck is 'more likely' somewhere else? (3)Any words of caution?   thanks!  

In windows server 2008 standard edition feature Failover clustering is not looking

In windows server 2008 standard edition feature Failover clustering is not looking.Yet microsoft is telling that we give 2 node cluster support on 2008 server standard edition.Therefore I have suggested the company to buy it and now I am fixed due to this.  Please Help  "SQLSERVER DBA" "INDIA"

SQL Server 2008 R2 Clustering Questions?

Hi All, I have got bit Idea for my question from http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/bff2b555-f25e-4644-a58f-264611818971 I have several questions 1. We have two Serves with Different Configuration (Server Model, CPU, Memory, etc.). Can we do Active-Active Failover Clustering on the same? 2. Can we do Database Level Clustering in SQL Serve 2008 R2 3. Where I will get Documentation for Clustering SQL Serve 2008 R2? Thanks, Ashish K India  

Is there any article or webcast for how to set up a SQL Server Clustering in Hyper-V environment?

I have already set up a Windows Server 2008 R2 Enterprise x64 with Hyper-V installed for trying out different features in SQL Server.  I'm interesting in trying out SQL Server Clustering.  I have only set up Windows 7 Enterprise x64, Windows 7 Pro x64,  and Windows XP PRO SP2 x86 VMs.  Can I use this VMs for SQL Server 2005 or 2008 Clustering?  Is there any article or webcast for how to set up a SQL Server Clustering in Hyper-V environment?


Hi Team,   can any body please guide me how can i install clustering in MS SQL SERVER 2008   What are requirements we need. to check before installing      subu

Windows 2008 R2 Clustering docs

Evening, Can someone point me to a step-by-step doc to set up clustering on a Windows 2008 R2 server. Need doc(s) to first install clustering on the server and then doc(s) to install a SQL Server cluster on the server. Thanks!

Setting Up Clustering "Piece Meal"...


I received a request frm a group here and wanted to run it by the forum just to affirm what I'm thinknig already.

They would like to create a cluster, which in and of itself is no big deal. How they want to is another matter. They currently have a box they want to use as a primary node. They want to install SQL Server on that box. But then they want to create the cluster. But the shared storage is not available yet.

I told them there's no way to create a cluster without the quorum being there which will be on the shared storage. Actually, they could create the quorum on a local disk, but why????

Eventually this wil be a two node cluster. To me it makes no sense to even try to install a cluster without having the shared storage attached, even if there's only one node in the cluster. It would just be a messy undertaking from my opinion...



A. M. Robinson

SQLServer 2008 install failure for clustering on Server 2008 R2 with clustering

Where Did i go wrong ?? everything tests okay..It just fails to install to the shared drive, nothing ever gets written to the disk.. Im so stuck..
Reporting services, shared services, books on line.. all install great..Database engine install just bombs.

Overall summary:
  Final result:                  Failed: see details below
  Exit code (Decimal):           -2068774911
  Exit facility code:            1201
  Exit error code:               1
  Exit message:                  Failed: see details below
  Start time:                    2010-09-29 16:10:37
  End time:                      2010-09-29 16:26:00
  Requested action:              InstallFailoverCluster
  Log with failure:              C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100929_160832\sql_engine_core_shared_Cpu64_1

SQL Clustering error

(Windows 2008 & SQL Server 2008)

After installing SQL Server on my 1st node I got error as mentioned below. i look into summary.txt & detail.log & didn't find much information beside the error as mentioned below. Cluster validation was done before installing SQL Server & it was passed without any failure or warnings.

Any help or pointer is appreciated.

The cluster resource 'SQL Server' could not be brought online. Error: the resource failed to come online due to the failure of one or more provider resources (Exception from HRESULT: 0x80071736)

SSRS 2008 and Clustering.



I am trying to install SSRS 2008 on a clustered environment. I have found so many contradicting views on web regarding SSRS and clustering. My understanstanding on SSRS and SQL 2008 server cluster(2-node) is that :

1. SSRS2008 is not cluster aware.

2. We can cluster the Reporting Databases. We already have a SQL server 2008 clustering. I guess, we need to install Reporting Databases on both of them.

3. We can install report server on each node in the cluster but that will not be cluster aware(the fail over does not take place).

4. Is there any way we can install report server on a cluster? Right now, we are planning to have one Report server that runs on the sql cluster which has Report databases in it(this  way Report databases are clustered). It would be nice if we could have report server also clustered.

Please advice.


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend