October 2007
July 2007
SQL Quick Reference
by 1 otherSQL Quick Reference from W3Schools. Print it, and fold it in your pocket.
March 2007
Sphinx - Free open-source SQL full-text search engine
ljseek.comis 120 plus gb database of live journal sites
July 2006
Introduction to Oracle - Tutorial Series - 1/5
SQL*Plus — schemata — data types — DML & DDL examples — editing commands — using external files — the dual pseudo-table — introduction to transactions — optional exercise — references.
Library of Free Data Models
by 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
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 2 othersDoes 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
(14 marks)