-
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…
-
Executing sql scripts using command line tools
SQL Server 2005 has a command line tool named sqlcmd. MySQL has a command line tool named mysql. Oracle has a command line tool called sqlplus. They can all be used for interactive query processing and batch scripts processing. They do similar things, albeit in different ways. They are functionally equivalent. For SQL Server 2005,…