-
Analyzing low performance SQL code
As an independent consultant and trainer , I found myself doing a lot of existing code analysis and enhancement, mostly for stored procedures and ad-hoc SQL statements. I suspect a lot of people do the same thing as well, so I am really interested in learning how you do it. That’s the main purpose of…
-
Calculating Sql Server logical reads using Perl
One important method for performance tuning is to decrease number of logical reads, by adding, updating, and/or refreshing indexes and statistics. To see if those changes make a difference for you, it is important to look at query statistics. Here is a sample output after set statistics io on: [sourcecode language=”text”] Table ‘Table1’. Scan count…
-
Drawing Swedish flag with Logo
After our last experiment, we drew a Swedish flag with Logo. Major code improvement: 1. Introduction of variable for flag size; 2. Using the direction keyword instead of turnright and turnleft to make it less ambiguous to the code reader. Here is the final product: Here is the code for it. # Begin logo code…
-
HP dv6253cl laptop fixed
It took me a while to fix the wireless problem on my HP dv6253cl. As documented here, I tried various ways to make the wireless card work on this laptop, to no avail. I tried 3 different distros: Sabayon 3.4, Ubuntu 7.1, and Kubuntu 7.1, with different Broadcomm driver combinations I found at ndiswrapper’s wiki…
-
Migrating from one RDBMS to another
Here is some of my thoughts on migrating MySQL to Sql Server. It came out of an email discussion. I’d love to hear your thoughts on migrating to a different database platform, not just MySQL to Sql Server. I actually thought about writing a white paper or even a course on migrating from MySQL to…