The big disadvantage I see for dynamic-only code is that you can't analyze them at all, whereas with views you can.

For example, "How many Configs use 'Integer3'?" or "Do we...

Has to be calculated in runtime so i cant just place them into a table and use identity column

Not following you there.  Why can't you look up the "meta-key" from...

The ORDER BY is useless (rather than "absolutely essential").  ORDER BY doesn't control the order of physical INSERTs into a table, only the assignment of identity values.  I've...

Actually I intended by code to be run anytime the Config for a given AttributeType was modified.  After the initial build for every AttributeType in Config, I expected it typically...

@pamkagel ,Do your insert in the following form...

 INSERT INTO dbo.yourtablename WITH (TABLOCK)
        (full column list here)
 SELECT full...

Btw, how then do you exec the code the function created?  Wouldn't you some type of loop / cursor to do that anyway?

I admit that I prefer using a cursor here to make it easier to adjust and customize the code.  As the OP stated, there will be special requirements for some...

No sir... There are a couple of "standards".  The "standard"...

Now, there's an interview question...

The ORDER referred to is when using BULK INSERT, for example loading a physical file into a table.

In those cases, adding "WITH ( ORDER(clus_key1, clus_key2) )" can allow SQL to...

(I originally used the wrong quote with my comments here, so I've repeated them below but with the correct quote first.)

• This reply was modified 5 years, 1 months ago by ScottPletcher.

A lot of places do tran log backups every 15 minutes.

No.  The human brain is designed to recognize patterns.  Sticking with a familiar patterns drastically speeds up...

1 min is just way too often.  Especially for only 1000 rows per day.  That's a miniscule load for SQL Server.

No.  The human brain is designed to recognize patterns.  Sticking with a familiar patterns drastically speeds up recognition of...