Wednesday, September 20, 2006
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'
EXEC sp_MSforeachtable "DBCC DBREINDEX ('?')"
EXEC sp_MSforeachtable 'UPDATE STATISTICS ? WITH FULLSCAN'
Subscribe to:
Posts (Atom)