-
My best investment so far
I’ve been using Jon’s excellent tools, ViEmu for Visual Studio, Outlook, Word, and Sql Server Management Studio for close to a year now. They make the default editor in those tools behaves like VI, with regular expression support. I bought the Enterprise Pack. Highly, highly recommended. Of course you need to know VI first. I…
-
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…