There are a gigantic number of tools out there that are free and extremely helpful. Since I’ve b ...
Earlier this week, I confirmed two full-day seminars I’ll be delivering in conjunction with SQ ...
Yes! This is month you could learn PowerShell and SQL Server Management Object ( SMO ) techniq ...

Indexing Fact Tables in SQL Server

[ 2015-06-06 08:54:01 | by 店小二03 ]
This article applies only to SQL Server as it is using clustered and nonclustered indices. It doe ...
I got a case recently where the customer had a SQL Alias setup but was having issues connecti ...
In any new release of SQL Server, one of the features that I first explore is the DMV enhancemen ...
We learn from mistakes and we improvise with experience. I couldn’t think of a better example th ...
一:各个数据中的连接符 SqlServer的连接符:+(加号) Sqlite的连接符:.(点) PostgreSQL的连接符:||( ...

简单sql部分强化练习题

[ 2015-06-06 01:54:01 | by 店小二04 ]
简单查询部分sql练习题 -- 选择部门30中的所有职工 select * from emp where deptno = 30; -- 列出所有业 ...

关于sqlplus用法的一些总结

[ 2015-06-06 02:00:01 | by 店小二04 ]
SQL select * from v$version where rownum=1; BANNER ------------------------------------------ ...
SQLserver 可以把镜像和复制同时部署,结合了双方的高可用性,可以使数据库得到更好的高可用性和容灾的保证 ...

Getting Started With Always Encrypted

[ 2015-06-05 11:36:01 | by 店小二03 ]
The recently released SQL Server 2016 Community Technology Preview 2 introduced Always Enc ...
In therecent articles published on this forum, we have been describing the process of preparing ...
SQL Server 2016的一项新特性是可以在“内存优化表(Memory Optimized Table)”上添加“列存储索引(Co ...
HP recently announced (see HP Announcement ) the certification of the powerful scale-up Superdom ...
There have been a number of questions on the #sqlhelp hashtag on Twitter recently about SQL Clust ...
玩转SQL Server复制回路の变更数据类型、未分区表转为分区表 复制的应用: 初级应用:读写分离、数据 ...
We had some great questionsabout trivial execution plans in SQL Server in our Advanced Queryi ...
Most CPUs as we know them are based on the “Von Neumann architecture” : The Von Neu ...
Clustered Columnstore Indexes (CS Index) were one of the two headline features for SQL Server 201 ...
这个问题会在参数话的SQL语句(例如存储过程)与SQL Server里的计划缓存机制结合的时候会出现。这个文章 ...
假如excel表格中有A、B、C三列数据,希望导入到数据库users表中,对应的字段分别是name,sex,age ,在你的exc ...
Tip: 环境 windows8.1 64位 + xampp1.8.1 + postgresql 9.3.6-2 第一步: php.ini中开启pgsql扩展 extensi ...

sql中select语句详解及用途

[ 2015-06-08 03:18:01 | by 店小二05 ]
SELECT ) ] ] * | expression ...
PART III:Thinking in Sets CHAPTER7 Thinking in Sets The three mostcommon set operations are as f ...