Posted in Friends & Family, Photos on June 28th, 2008 No Comments »
Today is the first weekend that I feel relax after l was looking for a new job and started working for another company. I brought my family to Laguna beach. It is not far from my apartment. It is Marvin’s first time to touch the ocean. He was very exciting. I took some photos. Laguna […]
Posted in SQL Server on June 22nd, 2008 No Comments »
In my previous post “What is Fragmentation and How to Defragment a Table Being Used Consistently?”
I told you that DBCC INDEXDEFRAG command was the solution to defragment in a 24/7 environment. This is only true for SQL 2000.
In SQL server 2005. There is a new way of dealing with it. When you set up […]
Posted in SQL Server on June 21st, 2008 No Comments »
In a recent problem that I was trouble shooting with, I was told that a store procedure which had been running well for a long time was
taking exceptionally long time to run and experienced “lock timeout“. When I used the sp_who or sp_who2 system store procedure to look at the running processes one told […]
Posted in SQL Server on June 11th, 2008 1 Comment »
A coworker came to me for help today when he tried to add two columns on to a very big table that contained 165 million records. He added these two columns to the table using SQL server management studio and after waiting for almost two hours he got query timeout message. So I looked […]
Posted in Blog Income, Others on June 9th, 2008 No Comments »
Here are the information of blog income in May 2008. It was down from April. There was a problem on Google Analytics and the traffic statistic in April and May may not be correct. Compare to April, May has 25% more unique visitors but traffic is about the same. And the traffic down […]
