There are lots of ways to do this, what will you be using it for?

Heh. Highly overrated if you ask me. 🙂

At the NASDAQ, one of the larger stock exchanges in the US, only 3 of 20 developers have expertise in T-SQL. As they are building a new application, they hope...

SELECT * From INFORMATION_SCHEMA.TABLES

Try it!

Yes, I can, and so can many of the other DBA's here. More...

Check out the DATEPART and DATENAME functions.

Instead of RETAINDAYS, try EXPIREDATE=dateadd(hh, 25, getdate()).

You can also do this with XML: Select all of the columns into an XML column/variable then extract the element(column) names of all of the matching elements(columns).

And of course this...

Can you explain how Page File increases can be affecting your CPU performance? And how you figured this out?

I notice that you do not have any exception handling. However, BOL has this to say about the GetEncoding method which you are using:

Note

Some unsupported code pages...

Like this:

INSERT Into {target_table} ( ..target_columns.. )

SELECT Distinct ..source_columns..

From {source_table}

Generally connecting can be, however implementing good security is another...

These are not scripts.

I am done here, this one is all yours Gus. 🙂

Yes, just apply the same technique that I did in my first reply.

Please post the CLR code.