Some MSSQL 7 Questions(200分)

Requires:

<BIG><BIG><BIG><BIG>
谢绝">>" "g" "@@" 之类
NO ">>" "g" "@@" or something alike please
TOO MUCH MAIL!
</BIG></BIG></BIG></BIG>

No book online, no English please.

Of cause, if English version be used, add Chinese version would be
acceptable

Examples are welcomed.

==================================================================

1. How do Stand By Server and Failover Support work in
Microsoft SQL Server 7.0? // 50 points

==================================================================

2. Some asked me questions and I answered:
a. Merge a Interbase table to a MSSQL 7 table.
Tow table has different structure.
INSERT INTO should be used instead of select into.
b. Merge from Interbase to MSSQL 7, no table exists
in target database.SELECT INTO can be used.

Of cause, I know I can use some tools, //10 points

Are these true ? I cannot tell the reason:-(

==================================================================

3. What can a full-text index do? How to use it? What's the cost? //50 points

==================================================================

4. How to use an application role? //50 points

==================================================================

5. What's File-Grooup? how does it improve our work. //40 points

==================================================================

both questions and points are to be continued...

1.使用两台服务器+磁盘阵列 ,做Cluster(集群).
其中一台服务器除了问题,只要Move到另外一台服务器,手工,自动均可.
不过,系统要求较高:
SqlServer 和 Nt需要企业版.
两台服务器配置尽量相同.
做集群难度比较大,单单安装就很麻烦,虽然有这方面的资料,好象有西德攻关秘籍
: First ... ,then ... Must ... Must not ...云云.
另外,运行也比较不稳定.
如果Cluster 失败,两台服务器一起罢工.

acceptable

呵呵, cj什么时候开始只许州官放火, 不许百姓点灯了
fulltext research is a special technology for database addon, almost
no db support it internally. so, to use it, most corp does like this:
build a keyword text, including the keywords of text u want to search,
then only search in this field. sounds easy, but the keywords selection
technology is not easy like it sounds especially for the native
language. english is much easier than east language like chinese
if u done this perfectly, u can go any corp and sell them the tech at
any price u want

呵呵，我想让大家看看嘛。
cytown:那么MSSQL的FULL-TEXT-SEARCH也是FOR ENGLISH的喽？
其它问题，大家继续，如果讲的好，分大大地

其实简单的做full-text-search是不分语言的, 只要%xxx%就可以了, 不过, 我说
的是更复杂的技术, 如, 一篇文章要提出关键字来, 只要查找关键字就可以了. 好的
引擎的关键是提取关键字的部分, 哪个是关键字, 断在何处. 英文断字很容易, 但
中文比较复杂了. 如果手工去提, 当然没问题, 但不是我说的这种了. 要做的是自动
提取关键字的技术.

cytown:i know that, but what about in mssql?

1.M$的BOL在这方面很好!!!!!! Delphi在这方面太臭了。
2.打字很慢，具体问题提出来讨论。

taik:
在下面写好贴上来吧
我去年过的MCSE，唯一没考出的就是ADMIN SQL（6），后来换了IMPLEMENT SQL
没看书，40分钟考了86X，呵呵。

我在帮别人复习SQL7 ADMIN，可他懂了，我却糊涂了//当老师的料，老师们莫怪
我下星期1去再玩一次ADMIN，5去考IMPLEMENT（7），理论上没什么问题的（本来是
想1/2连考，可2开始出差）

CJ:
你竟然还没考出... ??
怎么会?
? ?
O

考出了呀