BobAtDBS (3/25/2008)

---

Please, let's not start the religious war on whether blobs even belong in the database at all - that's not what this thread is about. For several reasons,...

Thanks for the link, Adam... that reminded me where I put my test code... and I added "EXCEPTION" to it...

First, I just don't trust execution plans, estimated or actual... especially...

Matt Miller (3/25/2008)

---

It looks like a cute technique, so I will keep it in mind. That being said - doesn't your quote above from BOL state that there must...

mrpolecat (3/25/2008)

---

No worky too good for me.

It added ok but when I select from the file all the fields fall under one field with the field name being the first...

Heh... sure... Just ask Al Gore... he "built the internet" and he's a grandfather :P:P:P

Carlos, your example would only fire the Insert Trigger once regardless of how many rows the Select returns. All inserted rows will be available in the INSERTED table available...

EDIT: Made a boo-boo... this originally said the following and I've corrected it below this white quote box... sorry for the mistake folks. :blush:

No... not with a linked...

Heh... I'm the same way... Wise man once told me that "All claims require proof... extraordinary claims require extraordinary proof."

In the Navy, we said (cleaned up version) "Why sift through...

Jason Selburg (3/25/2008)

---

Really? I'll have to keep that in mind and do some tests. It's not that I don't believe you, I'm just a see for myself kind of guy.

Now...

Adam Haines (3/25/2008)

---

Except operates as an outer join. It compares the results of both queries and returns distinct values of the left table. These are the values that...

Dunno if it's still true in 2k5, but when there are a large number of large image files as blobs, most folks recommend just storing the filename in the db...

Yep... you're gonna have to put the result of the CTE into a temp table as a separate query... include a RANK column. Then, see the part about "Grouped...

Chirag,

I'd worry about that problem more...

That would be true, ol' friend... and, in this case, simpler means faster and easier to read to...

Just my 2 cents on this one... I've found that the WHERE NOT IN that Barry used is usually more performant than outer joins. The speed difference isn't huge...