-
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…
-
Company Christmas parties
Companies in the US usually hold Christmas parties in December. I don’t know about other western countries, but I wouldn’t be surprised if they have similar customs. Normally, one should dress formally in these parties. For man, that means suit, tie, dress shoes, and such. I didn’t know that when I started working in the…
-
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,…