2013年2月25日
Rebuilding a heap
摘要： In 2005, rebuilding a table that was a heap (no clustered index) wasn't easy. You could copy it to a different table, or you could add a clustered index and then drop it.In 2008, this is a far easier thing to do. They have added to the ALTER TABLE command a method to rebuild the table, which is 阅读全文
posted @ 2013-02-25 17:27 Alex Tian 阅读(162) 评论(0) 推荐(0)
Comparison Operators Modified by ANY, SOME, or ALL
摘要： Comparison operators that introduce a subquery can be modified by the keywords ALL or ANY. SOME is an ISO standard equivalent for ANY.Subqueries introduced with a modified comparison operator return a list of zero or more values and can include a GROUP BY or HAVING clause. These subqueries can be re 阅读全文
posted @ 2013-02-25 11:21 Alex Tian 阅读(195) 评论(0) 推荐(0)