Posted in Technology on January 10th, 2008 No Comments »
Safari is the internet browser for Mac. Mac computer’s internet browser used to be Microsoft Internet Explorer but Apple decided to dump IE back in 2003 if I don’t remember it wrong. IE is no longer working on Mac. Anyway if you are brought to this post by search engine directly then most likely you […]
Posted in SQL Server on January 10th, 2008 No Comments »
Today I need to find out whether one of the SQL servers had performance problem because a monitoring tool developed in house was notifying us a store procedure call on a database server was timing out. In order to find out what was wrong with that store procedure I set up a trace using SQL […]
Posted in SQL Server on January 9th, 2008 No Comments »
Did you experienced a situation where a database was used by a high traffic 24/7 web application and somehow some important data got deleted and need a restoration? The database was located on a server that had a few other important databases and it was located in a data center far away and you couldn’t […]
Posted in MySQL on January 8th, 2008 No Comments »
I mentioned in my previous post “MySQL Bugs” that I observed a bug in its NT version 5.0.41.
The bug limited the number of concurrent connections to MySQL server to a very small number between 15 to 60 depending on innodb_buffer_pool_size. When you try to open additional connection to MySQL server you […]
Posted in SQL Server on January 6th, 2008 8 Comments »
I know for a long time that table function can be used just like a physical table to participate in a join in SQL query. An example is like the following
select B.* from tableA as A inner join dbo.tablefunctionB() as B on A.id = B.id
In the above query dbo.tablefunctionB() is a table function that returns […]
