-
TCP Chimney issue on Windows 2003 Service Pack 2
If you are running Sql Server 2005 on Windows Server 2003 SP2, you may get this message from Sql Server native client connection: An existing connection was forcibly closed by the remote host This is most likely caused by a “feature” called TCP Chimney offloading. On the server, run: Netsh int ip set chimney DISABLED…
-
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…