The Ji Village News

Category: Technology

  • Delete permission implementation differences

    I mentioned when grant statements take into effect in Sql Server, MySql, and Oracle here. I found out recently that there are some implementation differences when you grant only delete permission on a table to a user. MySql and Sql Server do this the same way, whereas Oracle is different. Suppose you have: 1. Table…

  • When does grant statement take into effect

    In both Sql Server and Oracle, permission changes to a user take into effect right away, even when said user is connected at the time you made the change. In MySql, it is a little different, depending on how the permissions are given. If you use the GRANT statement, then it takes into effect right…

  • Refresh lost wireless Internet connection

    I have WEP wireless connection at home. Sometimes, after waking up my computer from its hibernation state because of inactivity, I would lose internet connection. The wireless bar in system trey would still show excellent connetion, though. Here is how I solve this problem: 1. Go to command prompt; 2. Run this command: ipconfig /renew

  • Total row counts of all tables in a Sql Server database

    Sometimes you may want to know the total row counts of all tables in a database. The script below will give you a rough idea. However, it is not guaranteed to be accurate, though. It works in both Sql Server 2000 and Sql Server 2005. select sum(rowcnt) from sysindexes inner join sysobjects on sysindexes.id=sysobjects.id where…

  • Essential Software for Windows Machine

    Update 20100915: added WinSplit Update 20090830: took out anti-virus software. I now run Windows without it. Also, added CDBurnerXP. This entry was originally posted on November 22, 2005. I made some modifications to it. Right now I am giving Google Reader a try. Therefore FeedDemon is not part of my essentials anymore. I recently rebuilt…