-
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 […]
-
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 […]
-
TableDiff in Sql Server 2005
TableDiff is a great tool to compare the content of tables with the same structure. It is part of replication tools, but can be used for other purposes as well. This is the requirement of the tool, as spelled out in this error message: The replication table difference tool requires the comparison tables/views to have […]