- 博客(2)
- 资源 (6)
- 收藏
- 关注
RSS订阅原创 获取最耗时的存储过程
通过下面的T-SQL，即可轻松获取最耗时的存储过程的信息：SELECT TOP 10 OBJECT_NAME(a.object_id,database_id) SP_Name, DB_NAME(a.database_id) Database_Name, a.cached_time, a.last_execution_time, a.total_elapsed_time, a.total_e
2014-12-31 11:11:23
1923
1
原创 树莓派+Python+pyserial 2.7实现串口通信
手上有个CCD Camera(Barcode Reader/Scanner Module)，它是通过RS232通信的，用RS232转USB的转接线连接树莓派，即可完成硬件连接。对于串口通信，可以通过pyserial实现。首先，安装pyserial：从https://pypi.python.org/pypi/pyserial下载最新版本的安装包，再通过下面的命令完成安装：tar zxvf
2014-12-05 11:48:10
51521
3
transaction-log-management
This covers performing transaction log backup and restore, monitoring and managing log growth, including quick diagnosis of the causes of rapid growth, and optimizing log architecture to maximize log throughput and availability.
2013-06-06
How to boost DB server's performance
From this file,you can learn some tips of SQL scricp,useful DBCC commands etc. Besides, you can learn how to use SQL Server Profiler,DTA and so forth.
2008-09-25
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人