July 2006
Library of Free Data Models
by springnet & 5 others
(4) Database Design We have developed a Libary of free Kick-Start Database designs. These take the form of Data Models, created in a Modelling Tool called DataArchitect by PowerDesigner/Sybase. If you have a specific requirement that you can't find, then
Simon's Software Stuff: SQL Server performance tips
by springnet
Does your SQL statement have a WHERE clause? I know this sounds obvious, but don't retrieve more data than you need. However, less obvious is that even if your SELECT statement retrieves the same quantity of data without a WHERE clause, it may run faster
SQL Server Database Performance Tuning And Other Articles
by springnet & 2 others
Does your SQL statement have a WHERE clause? I know this sounds obvious, but don't retrieve more data than you need. However, less obvious is that even if your SELECT statement retrieves the same quantity of data without a WHERE clause, it may run fast
June 2006
May 2006
February 2006
December 2005
1
(10 marks)
