SQL Server提高性能的小技巧

2007-04-12 11:23 +0800

几个小技巧，用到了就记下来。我用的是SQL Server 2000,不是SQL Server 2005。

  1. 用 trauncate table 代替 delete table。节省做事务日志的时间和空间。当表很大时，节省的资源相当可观。
  2. 用 select into 代替 insert select。同样是节省做事务日志的资源，提高性能。
  3. 用 not = 代替<>。<>不能很好地使用索引。

参考文章

本文来自http://jijian91.com  原文http://jijian91.com/blog20070412/sql-server-improve-performance.html

Google
归类于： SQL Server — jijian91  
添加到网络书签：                                                                

评论

Good.Be the first to comment on this entry.

Post comment

comment has COPYRIGHT too！

Fields in bold are required. Email addresses are never published or distributed.

Some HTML code is allowed:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>
URIs must be fully qualified (eg: http://www.domainname.com) and all tags must be properly closed.

Line breaks and paragraphs are automatically converted.

Please keep comments relevant. Off-topic, offensive or inappropriate comments may be edited or removed.