Whoah! Where did you get the notion...

Don't get me started on this one (if not stopped, I will rant on until deep in the night..... :p)

[rant]

As a (senior) developer myself I've always, always stuck to the...

Given the example of the article I tend to avoid building foreign keys to bridge-tables, but rather build a 3-way bridge for the training:

Table Name: Employee_FunctionalArea_TrainingCourse

Column NameData Type

ID int (auto-increment,...

I think both the static table and the on-the-fly function have merits. Even when a static table is allowed I would still favor the dynamic solution when performance-requirements are not...

Hi Lynn,

I shaved off another 0-50% (depending on the total number of rows requested, better on lower quantities!):

CREATE FUNCTION [ufn_Tally3]

(

@Startbigint = 0,

@Endbigint = 4294967295,

@Incbigint = 1

)

RETURNS TABLE

AS

RETURN(

WITH

L16 (N) AS (

SELECT...

As pointed out randomizing the whole lot is rather pointless because of data-consistency and inter-relationships that need to be real(istic). Especially when trouble-shooting it is essential to have the exact...