1， 在自己的电脑上（服务器上此方法不能使用），打开运行，输入"cmd".

2， 执行下面这条语句，可以更新目录文本。

tree "ComputerNameh$Path" /f /a > .txtComputerNameh$PathDirectory

3， 回车运行，就可以在这个目录下生成最新的目录树文件-- Directory.txt。

 查看全文

http://www.oschina.net/project/lang/22/php

 查看全文

In this article I demonstrated how I go about detecting SQL Server problems in the form of excessive locking, and blocking. While this is a good start for the DBA detective, there is much more ground to cover. I mentioned CPU and I/O in this article only peripherally, as it relates to problem code. In my book, I continue on the path of analyzing performance issues, but extend this topic to explain how to make sure you get notified immediately of performance, and other, issues.

After all, if you do not know about the problem, you can't fix it. I would much rather be notified of a potential issue from a system that is monitoring such events than from an irate application user, or from the Help Desk. Granted, you will be hard pressed to totally escape emails from users and that is OK, generally they are understanding. It is their bosses that are not. If you can find and fix, or even just report, an issue before anyone else, it appears that you are ahead of the game. And you are … you are a DBA after all.

• System tables versus DMVs

• Tracking down database performance issues

• Using sp_who2

• Who is running the query?

• DBCC: What is the query doing?

• Killing the offending query

• Using sp_lock

• Automating discovery of problems

JSON 非常易学易用。所以，在短短几年中，它就取代xml，成为了互联网上最受欢迎的数据交换格式。

JSON 已经是 JavaScript 标准的一部分。目前，主流的浏览器对 JSON 支持都非常完善。应用 JSON，我们可以从 XML 的解析中摆脱出来，对那些应用 Ajax 的 Web 2.0 网站来说，JSON 确实是目前最灵活的轻量级方案。

可以强制以 -O lower_case_table_names=1 参数启动 mysqld（如果使用 --defaults-file=...my.cnf 参数来读取指定的配置文件启动 mysqld 的话，你需要在配置文件的 [mysqld] 区段下增加一行 lower_case_table_names=1）。这样MySQL 将在创建与查找时将所有的表名自动转换为小写字符

（这个选项缺省地在 Windows 中为 1 ，在 Unix 中为 0。从 MySQL 4.0.2 开始，这个选项同样适用于数据库名）。