Lynn Pettis (6/18/2012)

---

Duncan Pryde (6/18/2012)

---

kharol (6/18/2012)

---

Duncan:

I thought about parameter sniffing, but all resource I found about it was related to stored procedures. Nevertheless, I tried wrapping it in stored procedure...

kharol (6/18/2012)

---

Duncan:

I thought about parameter sniffing, but all resource I found about it was related to stored procedures. Nevertheless, I tried wrapping it in stored procedure that would do exactly...

If you can't rewrite the query easily, a quick fix that worked for me with a slow function suffering from parameter sniffing was to declare variables within the function, then...

UserName (which is the login name)

Welsh Corgi (6/19/2011)

---

Duncan Pryde (6/13/2011)

---

Welsh Corgi (6/13/2011)

---

Duncan Pryde (6/13/2011)

---

UserID would probably be the better option...

allmhuran (6/16/2011)

---

There are two ways to do this (three, but I don't think one counts).

One is to have a complete table for each entity describing all attributes. In your case,...

Welsh Corgi (6/13/2011)

---

Duncan Pryde (6/13/2011)

---

UserID would probably be the better option since it is possible...

Welsh Corgi (6/11/2011)

---

One thing that I noticied was that you may want to consider a UserType Table as opposed to UserTypeA and UserTypeB tables and separate columns?

I assume that you...

This problem is bugging me, since I feel there has to be a better/more elegant way of solving it. It is basically a specific case of the general "how do...

Good idea from Chris. I've not used the reverse technique before, so it looks interesting. What we have done on one large database is to create a indexed computed column...

terrykzncs (5/10/2011)

---

That was my example to show that the IN statement would be quicker. No, there isnt an index on the called number, and the table is huge, but I...

terrykzncs (5/10/2011)

---

Unfortunately it is a big table. If I use = and put the exact wording will that be faster? I will have to put about...

lance.kentwell (5/9/2011)

---

OK I think i have it as streamlined as possible. One question however. Is the order of your conidtions important? e.g. there is one condition I...

I should add: good question though, thanks.

Another one here who didn't read the question properly and thought it was talking about backup compression 🙁