2012年12月_fanth

12月 08月

原创 SQL SERVER查询效率最差的SQL语句

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTEDSELECT TOP 20 CAST(qs.total_elapsed_time / 1000000.0 AS DECIMAL(28, 2)) AS [Total Elapsed Duration(s)], qs.execution_count, SUBSTRING (qt.te...

2012-12-30 12:04:10 190

原创 SQL SERVER查询IO

select b.name,c.name,c.physical_name,a.num_of_reads,a.num_of_writes,a.num_of_bytes_read,a.num_of_bytes_written,a.io_stall_read_ms,a.io_stall_write_ms,a.io_stallfrom sys.dm_io_virtual_file_stats(...

2012-12-30 11:59:31 367

原创 SQL SERVER查询锁

with Lock(level, dbName,spid,blocked,sql_handle) as (select 0 as level, db_name(dbid),spid,blocked,sql_handle from master..sysprocesses a where blocked > 0union allselect level + 1 as Level...

2012-12-30 11:58:24 142

企业架构即战略的解读案例

数据解读及实战案例

2022-03-01

sonar-scanner-msbuild-2.2.0.24.zip

Sonar-Scanner配合sonarqube一起对java、安卓、js、vue代码进行静态扫描，找出bug，漏洞等问题

2019-06-13

网页打印工具，功能强大，支持套打lodop.rar

网页套打利器。仅供学习交流使用，商业用途请购买正版。

2019-06-12

空空如也

TA创建的收藏夹 TA关注的收藏夹

TA关注的人