Data Mining announcement
-
Link
Microsoft BI Labs went live today featuring a look into the future of SQL Server Data Mining in the Cloud. The SQL Server Data Mining team presents a set of prototype web services in the cloud that mirror some of the great predictive analytics functionality available in the Table Analysis Tools for Excel add-in from the SQL Server 2008 Data Mining Add-ins for Office package. No installation required.
This blog post provides more details.
Explore these predictive services from your browser - on your own data - and give us your feedback!
Found 3658 threads
-
0 VotesInserting into a temp table for null condition
Hello everyone, I have a temp table (#Northeastsum) created through code that is supposed to show revenue by month by producer (our sales reps). The code works but what I need, in ...
-
0 Votes
How to use a CASE statement within a sub select
2019 AND ProducerCode NOT IN ...Answered | 10 Replies | 3614 Views | Created by Barely_There - Thursday, August 6, 2020 3:27 PM | Last reply by Barely_There - Friday, August 7, 2020 1:52 PM -
0 Votes
SQL Server - Group By Sets as XML Elements and sub Elements
Dear Experts, I have a Requirement to convert the result into XML with the sub- elements in the set. Here are more details i have a table as ...Answered | 2 Replies | 4048 Views | Created by Momen Azmath - Monday, August 3, 2020 7:40 AM | Last reply by Momen Azmath - Monday, August 3, 2020 11:03 AM -
0 Votes
Need suggestion on sql join
Hello everybody, I want to outer join 2 tables, expected result as below, any suggestion to accomplish this, with many thank! Table ...Unanswered | 3 Replies | 3383 Views | Created by rupertlp - Monday, July 13, 2020 1:34 AM | Last reply by Tom Phillips - Tuesday, July 21, 2020 3:41 PM -
0 Votes
How to Send Cases that Belong to a Cluster into a table from DMX Query.
Hello, For my project I have performed clustering using Visual studio(SSDT) and I need to extract the rows involved in each cluster. I am able to ... -
0 Votes
Character Field Length
Recently SQL changed something. For over 13 years this code has worked and now suddenly is wrks differently. isnull(MAX(CASE WHEN ftr_opts.ftrcode = 'rpt_OutsideEdge' AND ...Proposed | 1 Replies | 3738 Views | Created by CNC_Macros_ - Tuesday, June 23, 2020 4:57 PM | Last reply by Tom Phillips - Tuesday, June 23, 2020 7:20 PM -
0 Votes
Ways to compare distribution by bin?
Hi I have a table, which has 4 columns with |Device_Model | Device_Id | Bin | DurationInBin| The ...Unanswered | 3 Replies | 3901 Views | Created by Niel1 - Wednesday, June 17, 2020 5:50 PM | Last reply by Laxmidhar sahoo - Thursday, June 18, 2020 11:27 AM -
1 Votes
Automated uploading raw data with cleansing
Hi I'm looking for a tool that automated uploading data to the SQL server and I also need to clean data before uploading. Do you have any suggestions tools except ...Answered | 3 Replies | 4335 Views | Created by ZaraJ - Friday, June 12, 2020 6:20 PM | Last reply by DBA_Atul - Friday, June 12, 2020 11:23 PM -
0 Votes
2 questions
Hi Eeveryone. I have a pretty simple test to do, just want to make sure i got it right! Attaching the test with my results, please ... -
0 Votes
Clustered Columnstore indexes on SQL Server 2016
Hi SQL Gurus, We are trying to enable change tracking on a DW table with a Clustered Columnstore index on it. The version of SQL Server we have ...Unanswered | 1 Replies | 4258 Views | Created by SQLNewbieNY - Wednesday, April 29, 2020 9:07 PM | Last reply by SQLNewbieNY - Friday, May 1, 2020 9:09 PM -
0 Votes
Classification of tweets in to categories
Hi ! Is it possible to categorize tweets into categories using Microsoft SQL server and without any coding. If yes, Kindly tell me the procedure to do the same. I want to categories ... -
6 Votes
Data Mining Add-ins for Excel 2016 where are they?
We currently use SQL server enterprise edition, we leverage the BI stack including the Data mining capabilities. Excel 2013 has working data mining add ins found here: ...Proposed | 16 Replies | 29044 Views | Created by DSqlAnalytics36 - Friday, August 11, 2017 5:33 AM | Last reply by Philip Wiest - Sunday, April 12, 2020 9:31 PM -
0 Votes
Replace XML Element key and value
Dear Experts, I have a XML as follows <items> <item key = "some text1" value = "some ...Answered | 2 Replies | 5097 Views | Created by Momen Azmath - Sunday, April 12, 2020 12:08 PM | Last reply by Momen Azmath - Sunday, April 12, 2020 1:51 PM -
0 Votes
Disable Data Mining
Can anyone point me in the direction of a solution, or step by step to completely disable Data Mining on an SQL server? I am assuming ports can be blocked, services disabled but I can not find a ...Unanswered | 1 Replies | 4630 Views | Created by Ryan Lashway - Tuesday, March 17, 2020 3:39 PM | Last reply by Ju_Fad - Thursday, April 9, 2020 4:24 PM -
1 Votes
15 Minute Groupings of data
I am trying to select data points in 15 minute intervals. I get the data I need but am unable to display a usable label (I am graphing the data on an ASP.net page). What I want to do is ...Proposed | 4 Replies | 16330 Views | Created by Garmon648 - Friday, May 21, 2010 2:16 PM | Last reply by Zoltán Horváth - Wednesday, April 8, 2020 5:54 PM -
0 Votes
Convert Bigint (18 Character) into Datetime2 and Datetime2 to Bigint
Dear Experts, I have a requirement to convert a Bigint to Datetime2 and datetime2 to bigint. I have been using the below @bigint ...Unanswered | 2 Replies | 5000 Views | Created by Momen Azmath - Monday, April 6, 2020 5:28 AM | Last reply by Momen Azmath - Monday, April 6, 2020 10:44 AM -
1 Votes
SQL backup job failed
Hi Guys, could you help me please resolved next Error: Error: 823, Severity: 24, State: 3. The operating system returned error 1450(Insufficient system ...Unanswered | 3 Replies | 5206 Views | Created by Mooner09 - Thursday, February 27, 2020 2:17 PM | Last reply by TiborK - Saturday, March 21, 2020 4:47 PM -
0 Votes
Can an SQL Query have an equivalent to a "IF" "then" statement? If so, do I use it ?
0 then find the matching IDs description and put in the group_description column, else leave both blank. my code (amended for brevity) looks like INSERT ...Unanswered | 3 Replies | 5291 Views | Created by G-Oker - Thursday, March 5, 2020 2:11 PM | Last reply by G-Oker - Friday, March 6, 2020 8:44 AM -
0 Votes
The equivalent of this Linq to SQL.
p.Bid).Max(), Low = DataSeries.Select(p => p.Bid).Min(), Close = DataSeries.Last().Bid, Volume = DataSeries.Sum(p => p.Volume) ... - Items 1 to 20 of 3658 Next ›
Data Mining announcement
-
Link
Microsoft BI Labs went live today featuring a look into the future of SQL Server Data Mining in the Cloud. The SQL Server Data Mining team presents a set of prototype web services in the cloud that mirror some of the great predictive analytics functionality available in the Table Analysis Tools for Excel add-in from the SQL Server 2008 Data Mining Add-ins for Office package. No installation required.
This blog post provides more details.
Explore these predictive services from your browser - on your own data - and give us your feedback!
