- 博客(4)
- 资源 (1)
- 收藏
- 关注
原创 恢复数据库时的Assembly错误
Msg 10314, Level 16, State 11, Line 52 An error occurred in the Microsoft .NET Framework while trying to load assembly id 65536. The server may be running out of resources, or the assembly may not
2013-11-15 09:30:35 1534
转载 Estimated and Actual Execution Plans
https://www.simple-talk.com/sql/performance/execution-plan-basics/ 文章已经分析的很详细了,另外补充一些。当分析一个超复杂的存储过程时,例如一个存储过程中又调用了多个其他的存储过程,且每个都很复杂,涉及多个insert,update语句。执行计划具有一下特点: 1, 执行计划按执行的先后顺序打印出所有insert
2013-11-12 14:15:07 1283
转载 SQL SERVER – Get Database Backup History for a Single Database
USE AdventureWorks GO -- Get Backup History for required database SELECT TOP 100 s.database_name, m.physical_device_name, CAST(CAST(s.backup_size / 1000000 AS INT) AS VARCHAR(14)) + ' ' + 'MB' AS bkSi
2013-11-05 10:15:35 1032
转载 Using Format Commands to Change Output View in powershell
不过总的来说很烂。。。。 http://technet.microsoft.com/en-us/library/dd347677.aspx
2013-11-04 16:24:08 716
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人