Tuesday, September 19, 2006

DBCC MEMORYSTATUS

Whenever you suspect memory problems in SQL Server 2000 use DBCC MEMORYSTATUS. Here is the KB article about how to interpret results.

Thursday, September 07, 2006

TDD vs RAD

I think the incompatibility between TDD and RAD is artificial. RAD is very useful for interfacng the external systems, like databases, web services and the user (UI is also the part of the external interface). TDD is very useful for developing business logic.

Friday, September 01, 2006

First thing to do when the execution plan changes

I need to run for every database:

EXEC sp_MSforeachtable "DBCC DBREINDEX ('?')"
EXEC sp_MSforeachtable 'UPDATE STATISTICS ? WITH FULLSCAN'