2022年3月28日
SQL Server查询扩展属性
摘要： select * from sys.extended_properties where major_id=object_id('Tablename') 阅读全文
posted @ 2022-03-28 17:44 夜丶珲 阅读(78) 评论(0) 推荐(0)
DevExpress.XtraCharts
摘要： using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Window 阅读全文
posted @ 2022-03-28 17:20 夜丶珲 阅读(388) 评论(0) 推荐(0)
SQL Server死锁查询
摘要： select request_session_id spid,OBJECT_NAME(resource_associated_entity_id) tableNamefrom sys.dm_tran_lockswhere resource_type='OBJECT' 阅读全文
posted @ 2022-03-28 17:11 夜丶珲 阅读(183) 评论(0) 推荐(0)
SQL Server缺失索引查询
摘要： SELECT user_seeks * avg_total_user_cost * ( avg_user_impact * 0.01 ) AS [index_advantage] ,migs.last_user_seek , mid.[statement] AS [Database.Schema.T 阅读全文
posted @ 2022-03-28 17:09 夜丶珲 阅读(260) 评论(0) 推荐(0)
OpenFileDialog、SaveFileDialog、FolderBrowserDialog文件夹路径获取
摘要： /****************************** ** SaveFileDialog ** ******************************/ SaveFileDialog saveFileDialog = new SaveFileDialog(); saveFileDia 阅读全文
posted @ 2022-03-28 15:41 夜丶珲 阅读(253) 评论(0) 推荐(0)