GitHub

Open Distro for Elasticsearch SQL

Open Distro for Elasticsearch enables you to extract insights out of Elasticsearch using the familiar SQL query syntax. Use aggregations, group by, and where clauses to investigate your data. Read ...
搜狐

MySQL 字段为 NULL 的5大坑，99%人踩过

从上述结果可以看出，count(*)和count(name)的值不一样，即当使用的是 count(name) 查询时，就丢失了两条值为 NULL 的数据。 解决 ...
搜狐

你还分不清各种JOIN用法吗？图解SQL，一看就会！

从业以来前面的几年主要在做客户端开发，用到的数据库都是表结构比较简单的 SQLite，以我那还给老师一大半的 SQL 水平倒也能对付。现在转岗做后端开发，就显得有点捉襟见肘了，特别是各种 JOIN，有时候傻傻分不清楚，于是索性弄明白并做个记录。 前言 在 ...
GitHub

SQLServer_Memory_Information.sql

WHEN CHARINDEX('Memory Manager', object_name) > 0 THEN 'Memory Manager' WHEN CHARINDEX('Buffer Manager', object_name) > 0 THEN 'Buffer Manager' WHEN CHARINDEX('Plan ...
TechRepublic

How do I assign permissions to users to see SQL Agent Jobs?

You can give your users rights to check if reports have run or jobs are complete without granting full admin rights. Here’s how you can do so by using SQLAgentReaderRole in SQL Server. We may earn ...
TechRepublic

Learn the differences between Is Null and IsNull() in Access

How many null values exist? What is the difference between a null value and a blank entry? This article answers those questions and more by discussing what to look for when creating Access apps that ...