mister.magoo (4/13/2011)

---

Ninja's_RGR'us (4/13/2011)

---

I guess I wasn't clear. It takes both. Prepending alone is not enough, it takes EVERYTHING varchar. Even a single nchar in there screws it...

Posting final code... prepending with "correct" order of the tables...

DECLARE @Exec VARCHAR(MAX)

SELECT @Exec = ''

SELECT @Exec = 'UPDATE STATISTICS dbo.[' + CONVERT(VARCHAR(200),name) + '] WITH FULLSCAN ; ' +...

mister.magoo (4/13/2011)

---

Ninja's_RGR'us (4/13/2011)

---

mister.magoo (4/13/2011)

---

That is definitely one to remember! Glad it worked for you as well, as there was the possibility in my mind that it might be version specific.

I...

mister.magoo (4/13/2011)

---

That is definitely one to remember! Glad it worked for you as well, as there was the possibility in my mind that it might be version specific.

I am using...

Genius!!!

Exec size : 670535

SQL Server parse and compile time:

CPU time = 0 ms, elapsed time = 0 ms.

SQL Server Execution Times:

CPU time =...

Brandie Tarvin (4/13/2011)

---

Ninja, I only asked because I thought...

mister.magoo (4/12/2011)

---

I have also done a bit of testing and found that after your variable gets to a certain size (dependent on the amount of data you are adding each...

This thread is not how can I make this work, it's about why the heck does this concat take so long.

So in that respect I think we can close it.

Thanks...

Just run the query that uses msdb... I think it'll work but I'm not sure and I can't test.

Oliiii (4/13/2011)

---

It's trivial to get the file size without free space.

You do need the free space to plan...

Never been my first choice since it's "unsupported". I like to make code that'll work...

mister.magoo (4/12/2011)

---

Bearing in mind the length considerations, this code now runs in 5 seconds for me for 9000 tables (the xml type fix doesn't work for me as I have...

Jeff Moden (4/12/2011)

---

Ninja's_RGR'us (4/12/2011)

---

I don't have a complete list of bad characters and I've got no idea about that type thing you're asking about.

All I know for sure at this...

Thank you all. I'm off site and I'll have to wait tomorrow to test Jeff's version of the code. Since "my" for xml was running in 16 ms...

Just for the sake of readability

DECLARE @SelectedEntity as int

DECLARE @Region AS nvarchar(4000)

DECLARE @Country AS nvarchar(4000)

set @Region = 'A4037F-1067-DF11-84EF-0017A4776866'

set @Country = '577A9867-1967-DF11-84EF-0017A4776866,577A9867-1967-DF11-84EF-0017A4776866'

SET @SelectedEntity = 1

DECLARE @SQLFields1 AS varchar(8000)

DECLARE @SQLFilter1 AS varchar(8000)

set...