-
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…