YangLong's Blog

累了就睡觉，醒了就微笑

SqlServer分区表

SQL Server Partition Table

SqlServer 分区表 Partition Function Create Partition Function ```sql create partition function 分区函数名() as range [left/right] for values (每个分区的边界值,....) –demo CREATE PARTITION FUNCTION demoParti...

Posted by YangLong on April 3, 2017

dm_exe_query_status 的应用

dm_exe_query_status tool

dm_exec_query_stats的使用 Returns aggregate performance statistics for cached query plans in SQL Server. The view contains one row per query statement within the cached plan, and the lifetime of the r...

Posted by YangLong on April 3, 2017

dm_exe_request的应用

dm_exe_request tool

dm_exec_requests的使用 Returns information about each request that is executing within SQL Server 查询当前SQL Server中正执行的请求 Column Name Data Type Description ...

Posted by YangLong on April 2, 2017

SqlServer性能分析设计

SqlServer性能的记录&性能分析

Performance Tools 性能分析工具数据性能分析主要使用的是SqlServer中的分析功能据dm_exec_request,dm_exec_query_statu以及当前数据库死锁状态三个工具进行分析 dm_exec_request Returns information about each request that is executing within SQL Ser...

Posted by YangLong on April 1, 2017

C# 语言变更历史

C# language edtion history

.Net Framework 的版本信息 .NET Standard 1.0 1.1 1.2 1.3 1.4 1.5 1.6 2.0 .NET Core 1.0 1.0 1.0 1.0 1.0 1.0 1.0 2.0 .NET Framework 1 4.5 4.5 4.5.1 4.6 4.6.1 4.6.1 4.6.1 4.6.1 Mono 4.6 4.6 4....

Posted by YangLong on March 27, 2017

Dapper的应用

Dapper简介&Dapper应用

Dapper 轻量级.Net平台的ORM框架基于ADO.NET的Connection的扩展 Execute a query and map the results to a strongly typed List 查询并转换成强类型列表 public static IEnumerable<T> Query<T>(this IDbConnection c...

Posted by YangLong on March 25, 2017