Two years ago I started supporting a Classic ASP application that used SQL 2000 for the data base. One of the complaints of the owner was that the previous person supporting the application did not keep track of program changes. The development environment was undocumented. A test system existed but it was in an unknown [...]
Entries Tagged as 'sql'
SQL Server and Subversion
April 10th, 2010 · No Comments · sql
Tags: sql·sqlserver·subversion
Tips, Tricks, and Advice from the SQL Server Query Processing Team : Understanding SQL Server Fast_Forward Server Cursors
August 24th, 2009 · No Comments · sql
Here’s a big thank you to Marc for this post on Fast_Forward Cursors. I happened to be debugging a performance problem with a SQL2000 stored procedure today. We have a stored procedure we use to release back orders and it was timing out. When I looked at the execution plan, SQL was using the date [...]
Tags:
Top free tools for Windows server administration
April 9th, 2009 · No Comments · IIS, sql
Every so often you find a tool you have never heard of. This week the tool that caught my attention was Performance Analysis of Logs (PAL). It was recommended by Bruce Mackenzie-Low in a newsletter from SearchWindowsServer.com and it looks it will be helpful with the “art” of performance analysis. I played with it a [...]
