I have two sessions that I will be presenting in Iowa City, hope to see you there. In ...

Reusing T-SQL Code

[ 2015-05-28 22:06:01 | by 店小二04 ]
Database programmers are often caught in the paradox of wanting to implement business rules and ...

SQL 2016 Preview has been released!

[ 2015-05-28 22:12:01 | by 店小二04 ]
For those who haven’t noticed already: SQL Server 2016 CTP2 (or Preview as some call it) h ...
With this new beta release of SQL Server we get a better insight in what we can expect in the ful ...
Today while working on SQL Server configuration I faced this strange error. Cannot connect ...

SQL Server to add JSON Support

[ 2015-05-28 20:06:02 | by 店小二04 ]
SQL Server 2016 is expected to offer native support for working with JSON. The first iteration of ...
The first set of T-SQL window functions have been available for 10 years, but many SQL Server pro ...
Problem A business analyst recently asked me three questions. The questions are: How do I conve ...
在三周前的 Microsoft Ignite 大会上,该公司宣布了 SQL Server 2016 ,而紧接着的下一代微软旗舰级 ...
案例环境: 服务器A系统:Windows Server 2000 数据库版本 :Microsoft SQL Server 2000 - 8.00.2 ...
今年是一个不平凡的一年,接触到了很多新艳的,让人兴奋的东西,虽然自己的牙掉了两颗,但感觉自己又年 ...
我只在数据库选项已开启“行版本控制的已提交读”(READ_COMMITTED_SNAPSHOT为ON)中进行了观察。 因此只 ...
有关数据表的操作数据库基本操作 用 MySQL,目前(版本 3.23)你可以在三种基本数据库表格式间选择。当你创建 ...
-- 先模拟环境,后面说明: USE GO -- DROP TABLE TRUNCATE TABLE CREATE TA ...

SQLite的使用介绍

[ 2015-05-28 15:18:01 | by 店小二04 ]
一、为什么要使用SQLite   SQLite是目前最流行的开源嵌入式数据库,和很多其他嵌入式存储引擎相比(No ...
一.WITH AS的含义 WITH AS短语,也叫做子查询部分(subquery factoring),可以让你做很多事情,定义一个 ...

SQLSERVER的bug

[ 2015-05-28 15:30:01 | by 店小二03 ]
今天客户反馈发现MS SQL里面有个bug,问题还蛮大所以发出来做个标记: 打开sql的查询窗口,贴入代码如下:d ...

What's New in SQL2016 CTP2 Release

[ 2015-05-28 13:06:01 | by 店小二04 ]
SQL Server 2016 CTP2 -- Now Available for public download. In CTP2 release, there are many new MD ...

第9/24周 理解执行计划

[ 2015-05-28 11:36:01 | by 店小二03 ]
欢迎回到 性能调优培训 。今天标志着第3个月的培训开始了,这个月我们全部学习SQL Server里的执行计 ...

SQL Server IaaS and Retry Logic

[ 2015-05-28 09:36:02 | by 店小二03 ]
Recently I had an interesting discussion with a customer and a question came up: should we still ...
Microsoft's given itself a busy day, releasing the first technology preview of SQL Server 2016 an ...
By Steve Bolton ………… The same rules that applied to my amateur mistutorial series on A ...
虽然存储设备是为容量而生,正确的存储类型还能让虚拟化的应用程序运行得更好。 存储设施保存数据的 ...
One of the most common performance bottlenecks that I see as a consultant is inadequate storage s ...

Announcing Live Query Execution Plans

[ 2015-05-28 08:48:02 | by 店小二05 ]
Behold! Live query execution plans This is new in the preview of SQL Server Managemen ...