大数据

redis入门 redis的常见五种数据类型 String类型 String类型，类似于java中的String类型，常见使用get，set方法。 String类型还可以存储json字符串格式。 Hash类型 Hash类型，也叫散列，它的value是一个无序字典，类…

概要 1 select 与 from2 关键字where 筛选3 关键字group by 分组4 group_concat 与 concat5 having 过滤(分组之后用)6 关键字distinct 去重7 关键字order by排序8 关键字limit分页9 关键字regexp正则10 练习  详细 …

前置知识 在 MySQL 中，GROUP BY 关键字可以根据一个或多个字段对查询结果进行分组 在有 GROUP BY 操作中，SELECT 后面接的结果集字段只有两种：要么就只有 GROUP BY 后出现的字段，要么就是 GROUP BY 后出现的字段…

1、日志错误提示 Microsoft OLE DB Driver for SQL Server: Unable to load msoledbsqlr.rll due to either missing file or version mismatch. The application cannot continue. 2、原因分析 This appears to be …

<p><iframe name="ifd" src="https://mnifdv.cn/resource/cnblogs/iot_terminal_management" frameborder="0" scrolling="auto" width="100%" height="1500"></iframe></p> <iframe fra…

当修改计算机名时， 需要修改sql server中对应的服务器名， 否则将影响“发布/订阅”，“镜像集群”等功能。 1、查询机器名 select @@serverName,  serverproperty('serverName')  2、修改机器名 EXEC sp_dropserver '…

转自：https://blog.csdn.net/nanchengyu/article/details/105627704 1.定义 一条SQL语句，正常执行的时候特别快，但是有时它就会变得特别慢，并且这样的场景很难复现，它不只随机，而且持续时间还很短，这样的情况…

by Myles Gilsenan I attended Oracle OpenWorld (OOW) 2014 recently with a focus on BI, Big Data and ERP. As usual there was no shortage of information. The Partner briefings were particularly helpful …

by Chaithanya Kumar Taduvai ODI developers usually deal with load plans and mismanaged dependencies between multiple-load plans are typically a cause of data corruption in the system. An ideal I…

Relative to traditional business intelligence solutions, Cloud BI is offering a timely and cost-effective path for businesses of all sizes to maximize potential while minimizing costs. To make the mo…