Platinum Sponsors
 

13th September 2008 Hatfield, Hertfordshire

Session Details - Small Problem - Simple Solution: Lookup Tables

Statistics say “25 – 30 % of all tables for an application are lookup tables”. Whether you are working on a “small” or “big” application it is worth analysing this problem and try to generalise the solution. Saving developer’s time is saving money, less code means less bugs, code once and reuse the code through the application(s). I’ll show you my thinking about this problem and give you some examples you can use in your applications. You can, of course change the code, improve it and modify the solution in any way.

Predrag Bosnic and Marko Markovic
Predrag Bosnic started his IT journey in 1979 using UNIVAC 1100, Fortran and Mapper. For the next 20 years he visited the world of PC, dBase, Clipper and Fox. During the last 10 years he has been working with SQL Server, BI and .Net maintaining his passion for databases and software development. He is a Software Development Manager, Developer, conference speaker and author of a dozen technical articles.

To view the presentation below in full screen double click on it.


Click here to view in local media player

Due to the size of these files we can only provided streamed versions.


Other sessions from this conference

A Testing Time... (Downloads) (Video)
A walk down memory lane (Downloads) (Video)
Advanced T-SQL (2005 and 2008) (Downloads) (Video)
Choices, Choices - Loading and Modelling Slowly Changing Dimensions in the SQL Server 2008 Suite (Downloads) (Video)
Data Vizualisation - Make your reports useful to business - No more "Speed Dials" (Downloads) (Video)
Does your cube support your users reporting needs? (Downloads) (Video)
Don't try this at work ! (Downloads) (Video)
End to End Report Creation and Management using Microsoft SQL Server 2008 (Downloads) (Video)
Getting more value from your data through data mining. (Downloads) (Video)
Head in the Cloud... (Downloads) (Video)
How to approach zero downtime database upgrades (Downloads) (Video)
Indexes Basically (Downloads) (Video)
Microsoft's integrated end-to-end BI offering. (Downloads) (Video)
Performance Monitoring Using SQL Server Management Studio - power of Management Data Warehouse (Downloads) (Video)
SQL Server – Under New Management (Downloads) (Video)
SQL Server 2008 for Developers (Downloads) (Video)
Understanding Query Cache and Query Plans (Downloads) (Video)
Useful Sql'y stuff that I've picked up over the years (Downloads) (Video)
Where’s my data? An introduction to Spatial Queries in SQL Server 2008 (Downloads) (Video)