Database good text favorites

Summary of methods for connecting to a remote database
The Enterprise Manager cannot remotely connect to the SQL Server server.
Http://topic.csdn.net/t/20030711/10/2015797.html
Http://community.csdn.net/Expert/topic/4785/4785190.xml? Temp = 4.006594e-02

How can I access a linked server or remote database in a stored procedure or trigger?
Http://community.csdn.net/Expert/topic/4765/4765998.xml? Temp =. 1525385.

Query analyzer logon to the remote server question ???
Http://community.csdn.net/Expert/topic/4958/4958684.xml? Temp =. 7166864.

How Can I copy part of the data in the upper table shard of one PC to another?
Http://community.csdn.net/Expert/topic/5004/5004813.xml? Temp =. 1137659.

This post mainly summarizes the methods for improving the query speed, including reducing the number of database connections, creating indexes, and optimizing statements.

This article about indexes is recommended for reprinting.Article
Http://blog.csdn.net/dutguoyi/archive/2006/01/10/575617.aspx

Improve SQL statement Efficiency
Http://community.csdn.net/Expert/topic/5087/5087396.xml? Temp =. 345669.
How to speed up the cable check with a large amount of data
Http://community.csdn.net/Expert/topic/5058/5058320.xml? Temp =. 1229517.
Index creationCubeDifferences
Http://community.csdn.net/Expert/topic/5068/5068154.xml? Temp =. 3010218.
Frequent insertion and deletion of data requires updating the index
Http://community.csdn.net/Expert/topic/4937/4937910.xml? Temp =. 8428614.
Tested SQL Server 2005 full-text search
Http://community.csdn.net/Expert/topic/4878/4878430.xml? Temp =. 6049311.

Other frequently asked questions about efficiency

How can I judge that the data in one table is not the best way in another table?
Http://community.csdn.net/Expert/topic/5038/5038742.xml? Temp =. 4704553.
How to delete Repeated Records in tens of millions of tables
Http://community.csdn.net/Expert/topic/5089/5089261.xml? Temp =. 7907068.

Database Data Query becomes abnormal Type Problems

The query results cannot be obtained after a period of stable operation.
Http://community.csdn.net/Expert/topic/4810/4810464.xml? Temp = 9.014529e-02