What is that UPPER(user_ID) good for that is used so heavily within your query?

If it's an integer you actually force it to an implicit conversion into an character value just...

As usual, "it depends".

If you have large XML data stored in that column it'll take a while to get the data due to the sheer volume.

The question would be: What...

Glad I could help 🙂

(Even though I still have some headache when thinking about somebody being forced to use NH... 😉 )

Jeff Moden (5/25/2010)

---

lmu92 (5/25/2010)

---

But...

wouldn't it be nice to have a SQL Server setting (like IDENTITY_INSERT), something like STRING_TRUNC with ON as a default (truncate strings, like it currently does...)? That...

But...

wouldn't it be nice to have a SQL Server setting (like IDENTITY_INSERT), something like STRING_TRUNC with ON as a default (truncate strings, like it currently does...)? That would allow us...

I have to admit that I try to balance "pipe load", overall performance and...

Your description is not very clear (at least to me it isn't)...

Please provide table def and sample data of your xml table together with a sample of your NewProductToSearchFor in...

honza.mf (5/25/2010)

---

...

I don't know our linguists (ÚPJC) but this will be very hard to do. Orthographic rules are very rigid and cannot be changed so easy. I remember last great...

Lynn Pettis (5/25/2010)

---

If you pay...

The best link I found so far: Gails blog[/url]

If you're using a c.u.r.s.o.r. within your sproc to process the data then this might be a possible cause, too...

You could either use a calendar table on the DB side and modify the query/view to use a left outer join on the calendar table or you could create one...

I'm confused....

If you can't explain the benefits of the fine tuning we you did, then why there was a need for tuning in the first place? Tuning for the sake...

I tend to use a delimited list if I have a predefined, repeating structure when calling the sproc.

But if I get something like "3 variable columns out of 20" I...

Here are some logic related questions:

What's the business rule for selecting the rows to show up in your final table?

Is it guaranteed that you'll never have more than 5 lines...