public marks

PUBLIC MARKS from springnet with tag sql

October 2007

July 2007

SQL Quick Reference

by 1 other
SQL Quick Reference from W3Schools. Print it, and fold it in your pocket.

March 2007

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 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