摘要：
Here are some guidelines for database size, object number and naming limitations contrasted across Access 2000/XP, SQL Server 7.0, SQL Server 2000, and MSDE 2000. The main reason for this chart was to answer the question "how many rows can I get into a table?" -- which doesn't have a direct answer, but is limited by many of the variables listed below (not to mention disk space!). 阅读全文
摘要：
This was going to be chapter 13 of a book that we pulled. Since I have no interest at this point in writing another intro level 7.0 book, you can enjoy it out here.
Perhaps one of the more compelling hands-off administration abilities of SQL Server is the SQL Mail capability. SQL Mail lets you send, receive and process mail from within SQL Server. The most common use of this is setting up the SQL Agent process to alert you to server conditions. Since many wireless devices (phones, pagers, e 阅读全文
摘要：
你的手機究竟有多安全﹖
我們經常拿著手機閒聊﹐以為沒有人會聽我們的談話內容。但是如果你坐過公共汽車、去過餐館或者去過電影院﹐你就會知道﹐這種想法是多麼地愚蠢。由於某種原因﹐將手機抵在耳朵上會讓你突然變得特別多話﹐而且聲音明顯放大﹐因此多多少少會有人聽到了至少一方的談話。那麼﹐是不是有些人還聽到了兩方的談話﹖這個難度究竟有多大﹖我們又該如何應對呢﹖
阅读全文
摘要：
All SQL Server 2000 versions (as well as several other Microsoft products; see KB #324998) ship with SQL Server 2000 Desktop Edition, often referred to as MSDE (Microsoft Data Engine) 2.0. Essentially, MSDE is a version of SQL Server that you can distribute with applications. As such, it is slightly lighter weight, and has some notable restrictions. Other than the following list, however, MSDE and the other editions of SQL Server have very similar behavior and performance characteristics (see Ar 阅读全文