Lynn Pettis (3/11/2010)

---

It could be me, but the execution plan for the UNPIVOT solution still looks a lot like the execution plan of the CROSS JOIN/multiple UNION ALL solution. ...

Thanks steve, and as for themes, you mention queries looking like skyscrapers.....

Attached is my execution plan - looks amazing like a chef's knife - perfect for slicing through the data....:-P

CPU time = 228886430 ms, elapsed time...

Isn't it just

exec sp_blah 'hardcodedvalue', 'hardcodedvalue', @ClientID

?

sharon.bender (3/9/2010)

---

Hi, I'm posting this for a colleague who is struggling with a trigger that won't fire off an insert statement.

...

However, later in the trigger, Server A sends an Insert...

I have given in to curiosity and set off THE TRILLION - should be done in a few days I guess?

@steve-2 - congrats - I think you have the record - I can't think anyone else will even attempt THE TRILLION after seeing it takes that long!

Without test data to work on this is difficult, but I think you are after something like this:

;WITH

FieldNames AS

( -- this is your list of dupes

SELECT FieldName FROM...

It all depends on how you decide which ones to keep...if you can write a query to select the IDs you want to keep then it is easy to use...

@BaldingLoopMan : That is exactly the same as this...

SELECT TOP 20

NAME,

object_id,

( SELECT COUNT(*) FROM sys.columns C where C.object_id=T.object_id )...

There is no straightforward answer as we cannot possibly know which ones you want to keep...

You can get the list of them , so you can use that to get...

balbirsinghsodhi (3/3/2010)

---

I having issue using script which create views in the batch. I am generating a views from the database based on all the tables and store those views on...

steve-893342 (3/3/2010)

---

Yes Mister Magoo that really is a very elegant solution indeed.

I've had a look at comparing against my query and it sure is a close one to call.

Re the...

steve-893342 (3/2/2010)

---

Too late now!

I experimented with those union queries but couldn't find the right one, probably having too many unions or too few. Did you arrive at 32...

@jason - thanks.

@steve-2 - yes - just about to try it, but I am not sure if my laptop will have enough memory - have you...