Data mining introduction part 4: the Naïve Bayes algorithm
This chapter explains the Naïve Bayes algorithm. How does it works, what information is displayed.
2013-04-15
10,691 reads
Daniel Calbimonte
- Skills: ssas, ssis, ssrs, Power BI, Azure
Data Mining Introduction Part 3: The Cluster Algorithm
This is the part 3 of the Data Mining Series from Daniel Calbimonte. This article examines the cluster algorithm.
2013-03-12
13,322 reads
Data Mining Introduction Part 3: The Cluster Algorithm
This is the part 3 of the Data Mining Series from Daniel Calbimonte. This article examines the cluster algorithm.
2013-03-12
12,681 reads
11 Tips to Backup databases with SMO, VB, C# Powershell, Command lines
Sometimes we need to create backups using code. Sometimes we need to do it manually or automatically, programmatically using C#, VB, Powershell.
2012-08-14
7,494 reads
The User Defined Server Roles in SQL Server 2012
This article describes how to create user defined server roles and use stored procedures and queries related.
2012-05-25
4,502 reads
New features in SQL 2012, the contained database
This article describe the problems about the migration of the databases and logins and the new feature contained databases
2012-05-22
10,827 reads
Run SQL Server Scripts using C#
In this article I will run a SQL Server script to backup a database using C# in visual studio. For this purpose, I am going to use the sqlcmd.
2012-04-27
17,590 reads
Linked server to MySQL Server.
In this article, we are going to create a linked server to the MySQL Database.
Once finished that task, we will select, insert, update and delete some data using SQL Server.
2012-04-17
9,788 reads
Sequences in SQL Server 2012
This article describes the sequence new feature used in SQL Server 2012
2012-04-13
9,375 reads
Bye Bye to the RAISERROR Function?
This article describes the use and advantages of the throw statement.
2012-04-03
2,667 reads
Blogs
Monday Monitor Tips: Knowing Your RPO
By Steve Jones
A customer was asking recently about the RPO for their estate, and I showed...
Webinar tomorrow: The Role of Databases in the Era of AI
By Steve Jones
I’m hosting a webinar tomorrow with Rie Merritt from Microsoft. We’ll be talking about...
Spark Connect Dotnet Variant Data Type
By Ed Elliott
All Spark Connect Posts I recently published the latest version of the Spark Connect Dotnet...
Forums
Table Partitioning SQL server 2022
Hi All, I am currently testing the Table Partitioning to implement in SQL server...
STRING_AGG's behavior
Comments posted to this topic are about the item STRING_AGG's behavior
The Role of Databases in the Era of AI
Comments posted to this topic are about the item The Role of Databases in...
Question of the Day
STRING_AGG's behavior
Executing the following script (Sql Server 2022), you get the table t0 with 10 rows:
CREATE TABLE t0
( id INT PRIMARY KEY
, field1 VARCHAR(1000)
, field2 VARCHAR(MAX));
INSERT INTO t0
SELECT
gs.value
, REPLICATE ('X', 1000)
, REPLICATE ('Y', 1000)
FROM generate_series(1, 10, 1) gs;
GOWhat happens if you execute the following statements?
select STRING_AGG(field1, ';') within group (order by id) from t0;
select STRING_AGG(field2, ';') within group (order by id) from t0;