GilaMonster (12/3/2007)

Why would you say that?

I'd say B. Dates should be stored in datetime columns, not seperated out. There are a couple of good reasons

There are some quite...

Sergiy (12/1/2007)

Well, procedure is doing the same thing to the same object (or, better, "object").

If...

I still want to know why it's necessary to return a 42 million row result set... THAT's the performance problem... especially if ANY of the "dim" tables are actually, ugh,...

You can gain some very fine control over the "order" of what get's done by triggers... put all the code in the correct order in one trigger.

Heh... no... I can't... don't have 2k5...

From what I understand, Cross Apply has some performance limitations... I was looking...

And Vivian's good script lists the FreeSpace in Mega Bytes.

Heh... You weren't supposed to remove the TOP... thought you only wanted ten random names at a time... and I sure didn't know you had a list of over 20,000...

Can you post what some of the output looked like? Thanks.

Ummm... maybe you can do it using OPENDATASOURCE or OPENROWSET...

Can't be done using EXEC... temp table must already exist.

Why do it two different ways?... and have one crawl if the scalability increases?

Dunno about others... but I've not needed anything but T-SQL with occasional trips through xp_CmdShell to use some "DOS" functionality.

Triggers operate quite differently between RDBMS's... if you really want to know about triggers in SQL Server, read about them in Books Online instead...

Did you try any of the things I posted?

Also, why are you returning 42 million rows instead of a summary of the rows?

Whilst we wait...

CREATE FUNCTION dbo.ProperCase(@pString VARCHAR(8000))

/**********************************************************************************************************************

Purpose:

This function will change all letters to lower case and then change the first letter that follows any non-alpha

character to an...