- 博客(11)
- 收藏
- 关注
原创 select into VS insert select VS bulk insert 效率测试
--select into VS insert select VS bulk insert 效率测试--数据库恢复模式:简单--Basic tableuse tempdb;GOif(object_id('dbo.orders','U') is not NULL) drop table dbo.orders;GOcreate table dbo.orders(orderid int no
2017-05-16 20:17:51 802
原创 identity 完全测试
--identity--include: seed(initial value),step(increment value)--usage:surrogate key(代理键,业务无关,系统生成)--basic tableif(object_id('dbo.t1','U') is not null) drop table t1;GOcreate table dbo.t1(id int n
2017-05-16 17:21:30 811
原创 Insert Data Demo--插入数据的四种方式及测试
--Insert Data Demo--basic tableuse tempdb;GOif(object_id('dbo.orders','U') is not NULL) drop table dbo.orders;GOcreate table dbo.orders(orderid int not null /*identity(1,1)*/ constraint PK_orders
2017-05-16 17:07:46 1705
原创 Mysql text MEDIUMTEXT 在5.5和5.7中的差异及扩容测试
# text LENGTH#TINYTEXT: 256 bytes#TEXT: 65,535 bytes => ~64kb#MEDIUMTEXT: 16,777,215 bytes => ~16MB#LONGTEXT: 4,294,967,295 bytes => ~4GBselect version();# 5.7.17create table testTB (id int not nu
2017-05-10 11:23:45 905
原创 Mysql [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause
select version();# 5.7.17常规查询报错: [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column Trouble shooting过程(注意mysql5.7配置文件的路径):root@TESTDB:~# cd /ro
2017-05-10 10:25:51 805
原创 透视,逆透视,分组集 pivoting ,unpivoting ,grouping set
--透视,逆透视,分组集 pivoting ,unpivoting ,grouping set---------------基本数据use tempdbgoif(object_id('dbo.asktom') is not null ) drop table asktom;create table asktom(id int not null identity(1,1),adate dat
2017-05-09 20:46:28 353
原创 CentOS如何删除旧的内核(kernel)
(1)查看已经安装的内核命令:rpm -q kernel 显示结果: kernel-2.6.32-279.14.1.el6.i686 kernel-2.6.32-279.el6.x86_64 kernel-2.6.32-358.6.1.el6.x86_64(2)删除旧的内核方法一:安装yum-utls: yum install -y yum-utils 设置你想要保留多少旧的内核,比
2017-05-09 10:48:28 1043
原创 ubuntu crontab 不执行问题排查
定时任务脚本: 02 10 * * * nohup sh /opt/DBback/Backed/backup.sh > /opt/DBback/backup.log 2>&1 &1.脚本单独执行nohup sh /opt/DBback/Backed/backup.sh > /opt/DBback/backup.log 2>&1 & 正常,没有报错。2.开启日志,查看报错rontab记录日志
2017-05-09 10:45:26 514
原创 【Sqlserver】堵塞问题解决思路
背景: App userA:主要负责数据入库(线程较少) ; userB:负责数据查询和校验(线程较多,多为个人连接数据库查询)。 userA和userB之间经常会存在锁导致堵塞,从公司层面看,userA的是主体核心业务,userB是从业务。最好的改进方式是全任务的计划执行,在App改进之前,先用如下定时任务临时缓解问题。 - 操作:kill user=userB,而且堵塞
2017-05-05 20:13:22 468
原创 【Mysql】【子查询-left join改写】前端SQL调优
相关数据已经脱敏处理-- 原SQLSELECT * FROM (SELECT a.*, (SELECT sum(CASE WHEN (b.confidence < c.THRESHOLD * d.THRESHOLD AND b.KEY_N
2017-05-05 20:01:56 354
原创 sqlserver UNION-OR 改写一例
------原SQL info:select name=name,xtype=0,rowcnt=-1 from sysobjects with (nolock) where status>=0 and objectproperty(id,'ISUSERTABLE')=1unionselect name,1,-1 from sysobjects with (nolock) where statu
2017-05-05 11:28:50 591
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人