询问....SQL的意思...

panic_tee

请问各位大大:

1) Profilinf SQL Statements Proformance
2) Trace SQL Statements
3) Analyze isolation level of SQL statement
4) Fine-tune SQL Statements
5) Improve Store Procedures
6) Table Indexing
7) Maintanance Plan in server agent
8) Archive History data

这些是什么东西...有什么用吗?

请帮忙给我最简单的解释......谢谢~

soonyu

[quote]原帖由 panic_tee 于 11-10-2006 09:29 发表
请问各位大大:

1) Profilinf SQL Statements Proformance
- Capture sql statement run in the server wiht sql profiler

2) Trace SQL Statements
Trace using profiler tool come with  sql server

3) Analyze isolation level of SQL statement

4) Fine-tune SQL Statements
Fine tune sql which have poor performance. example slow response time, high read, high write.

5) Improve Store Procedures
improve sql statement / tunning sql statement in store procedure

6) Table Indexing
Create index in table for faster query. Can check Book online about index topic

7) Maintanance Plan in server agent
DBCC checkdb, backup db and etc. Mostly talking about database maintenance. Mantenance Template in SQL server

8) Archive History data
把旧的资料从table move 到 Archiving table.
After the archiving, data in live table become much smaller and improved performance when query

panic_tee

原帖由 soonyu 于 12-10-2006 12:25 AM 发表
原帖由 panic_tee 于 11-10-2006 09:29 发表
请问各位大大:

1) Profilinf SQL Statements Proformance
- Capture sql statement run in the server wiht sql profiler

2) Trace SQL Statements
Trace us ...

还是看没懂勒......

johe07

什么不懂？说出来。。。

panic_tee

原帖由 johe07 于 12-10-2006 12:47 PM 发表
什么不懂？说出来。。。

有华文的翻译吗?

不如说....比较少英文的解释...

goatstudio

要详细的解释可以到 www.whatis.com