摘要:
SQL Server Performance improvement How to know badly performing code and ways to improve it. Identify blocking or deadlocking activities Identify hard 阅读全文
摘要:
I tries to check the SQL Scripts several months ago, actually I didn't run any application which connected my database and also didn't run SQL Script 阅读全文
摘要:
今天有朋友让我帮看下其SQL Server Profiler的结果,如下图,通过观测其个性能参数发现SQL Server没有大的负荷;但是仍告诉我系统32G系统的服务器运行速度还是非常的慢,最后告诉她检查下系统的processes and the status of locks, and found 阅读全文
摘要:
当个执行Figure2中的语句出现,如下错误,结果用Figure1的查询真发现有提示的问题。结果把语句改为 SELECT * FROM TX1 a inner join TX2 b ON a.EmpNo=b.EmpNo COLLATE Database_Default,再次执行就OK了。 因此什么是 阅读全文
摘要:
若在Oracle的命令行模式下执行,先运行如下语句: set linesize 1000; 1.查看安装的oralce版本select * from sys.v_$version;或select * from v$version;或select * from product_component_ve 阅读全文