Note: This article assumes that you're an application developer or DBA, who is already familiar with writing SQL stored procedures.
注意:本文假设您是应用程序开发人员或DBA,而且已经熟悉如何编写SQL存储过程。
Learning SQL will give you a leg up when you're communicating your goals to the DBA team. They won't have to decipher your meaning and you can tell them exactly what you need.
学习SQL会在你与数据库管理员团队交流你的目标时给予帮助,他们不需要解析你的意思,你可以确切地告诉他们你的需求。
As you can imagine, for long complicated SQL, simply formatting the query can save hours of DBA time.
正如您所想象,对于很长的复杂的SQL,只是对查询格式化就可以为dba节省很多时间。
My good friend and business partner jokes that he became a DBA because SQL hasn't changed in 35 years. This is, largely, true.
我的好朋友和商业伙伴开玩笑说他成为一个数据库管理员是因为SQL已经35年没有变化了,这大部分是真的。
Because the developers chose JDBC or a JDBC-based framework, the DBA had limited tools to help the developer know what applications the SQL was coming from.
因为开发人员选择JDBC或基于JDBC的框架,所以dba只能使用有限的工具来帮助开发人员了解SQL来自哪个应用程序。
The developer can now improve the SQL (or work with the DBA to do so) and repeat the cycle until the SQL USES a desired access path.
现在,开发人员能够改进SQL(或与DBA合作完成)并重复此周期,直到SQL使用了期望的访问路径。
Tuning dynamic SQL queries was taking more time and effort for the Senate DBA group.
调优动态的SQL查询对于参议院dba团队而言需要花更多的时间和精力。
A DBA does not always have visibility into the type of changes in the application and SQL, but having this information available can help you understand and manage the change.
DBA并不能总是看到应用程序和SQL中的所有更改类型,但有了此信息有助于理解和管理更改。
The OAT provides the much needed information required by the DBA like the disk space usage, log files, SQL statements occupying the most IO time, the slowest SQL statements, and so on.
OAT提供DBA所需的大量信息,比如磁盘空间使用情况、日志文件、消耗IO时间最多的sql语句、最慢的sql语句等等。
For example, a database administrator (DBA) and an SQL expert should be involved from the start to participate in the discussions on how the different objects will be used.
例如,数据库管理员(DBA)和SQL专家应该从一开始就一起讨论将如何使用不同的对象。
It is possible to globally disable certain actions that the user will never want to grant consent to (for example, if the DBA always needs to gather the SQL data from the database).
全面禁用包含用户从不想授权许可的操作是有可能的(例如,如果DBA总是需要从数据库获取SQL数据)。
This new feature also allows a DBA to add new storage using the SQL API.
这一新特性还允许DBA使用SQLAPI添加新的存储器。
Collaborate effectively with the DBA for static SQL development.
与dba有效地合作进行静态SQL开发。
In the old SQL way though, the trigger way is more popular because is more secure from DBA point of view.
在旧SQL方法,触发的方法是更受欢迎,因为从DBA更加安全的观点。
In the old SQL way though, the trigger way is more popular because is more secure from DBA point of view.
在旧SQL方法,触发的方法是更受欢迎,因为从DBA更加安全的观点。
应用推荐