I'm afraid this can't be done. UDF cannot execute dynamic SQL.

Some possible alternatives:

a) Code it as a stored procedure

b) Use IF statements to code a distinct SQL for each table...

If the rebuild process takes 9 hours, this means it needs 9 hours.

If you stop it, it will start from scratch.

I suggest that you start using a different optimisation strategy,...

I had the same happening to me several year ago.

It turned out to be a port malfunction on the switch the server was connected to.

CREATE TRIGGER trg_Celko ON vw_SSC_PostList FOR AFTER INSERT

AS

-- Go read the documents, inline comments are for sissies.

IF EXISTS (SELECT * FROM inserted WHERE [Name] = 'CELKO')

BEGIN

DECLARE...

Try this:

SELECT CAST(DATEPART(hh,timer) AS FLOAT) + (CAST(DATEPART(mi,timer) AS FLOAT)/60)

FROM tblTimeRecorder

BTW, get rid of that "tbl" prefix on your tables before Joe Celko catches you...

Much longer than what? Another server? Compare the actual execution plans.

Do you get different plans? Compare indexes and statistics.

Which query? Can you post it? Can you post the actual execution...

Suggest? No whole numbers? What do you mean?

Can you post the results you're getting and...

How about this:

DECLARE @sql as varchar(max)

SET @sql = ''

SELECT @sql = @sql + char(13) + char(10) +

'IF EXISTS (SELECT blah_ID FROM [dbo].[' + o.name + ']...

Doesn't save a lot of headscratching 😉

Peso's code is incredibly smart. Full stop.

If there's one minor thing that can be criticized, personally, I prefer...

You can't.

See this: Using TRY...CATCH in Transact-SQL

Look for "Compile and Statement-level Recompile Errors".

Nice one, Peso!

Well, I wouldn't say "simple", I would say "short" instead! 🙂

Very nicely done, as usual.

Steve Jones - SSC Editor (10/27/2010)

---

I'll drop some topics out here for you. Here's a couple that I have saved up:

- Finding/changing the default backup location

- scheduling a trace

- duplicating...

Steve Jones - SSC Editor (10/27/2010)

---

BTW, speaking of technical stuff....

I wonder if any of you would be interested in writing to fill holes? I keep finding posts here, and elsewhere...

Nice catch, Wayne.

An alternative way could be checking the results of DATEPART(weekday) for known dates and replace the constants 1 and 7 with the variables.

DECLARE @Sunday int, @Saturday int

SELECT @Sunday...

Gail has a superb blog post on the topic:

http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/