Just fyi, I would avoid using scalar functions in WHERE clauses whether they are builtin like ISNULL or user defined like yours if possible. It creates the RBAR effect...

sjimmo (9/24/2010)

---

jeff.mason

It happens under the hood, and always has AFAIK. If there isn't a uniqueidentifier replication will add one to every table on the system and if replication is deleted,...

jeff.mason (9/24/2010)

---

Robert Frasca (9/24/2010)

---

jeff.mason (9/24/2010)

---

sjimmo (9/24/2010)

---

I use replication heavily in our stores, to move high priority data back and forth with...

jeff.mason (9/24/2010)

---

sjimmo (9/24/2010)

---

I use replication heavily in our stores, to move high priority data back and forth with HQ. I personally...

I got it wrong over the nullable column thing which I think is silly. While it's something to strive for, from a data architecture point of view, in 30...

Chris Howarth-536003 (9/16/2010)

---

You may see an improvement by adding the OPTION (RECOMPILE) query hint to the problem query - this will cause the optimizer to recompile the statement with knowledge...

I certainly understand the sentiment behind those thoughts and I'm certainly onboard but it really isn't a feasible solution to my dilemma. The turn around time for something like...

TheSQLGuru (9/15/2010)

---

I doubt this has anything to do with the way you put data into the temp table. It is all about TWO MASSIVE JOIN queries UNIONed together using...

Jeff,

Thanks for taking a look. I just want to clarify that the query isn't really the issue. I didn't write it and I don't know the business rules...

I agree, the query doesn't make much sense to me either but I didn't write it. I'm just trying to find some ways to optimize the performance without changing...

I appreciate your help but my goal is to find out why it works in one venue, i.e. a query window and not in a stored proc. Also, I'm...

The option must be selected as one of the properties of the article to be replicated. If you're using the GUI, right click on the article and choose "Set...

Group 1 - max(a) is 3 ---- nothing in b is greater than a

Group 2 - max(a) is 2 ---- 3 (in b which is the whole table)...

All right, I confess. I don't get it. the subquery says where b GREATER THAN a not LESS THAN. As near as I can tell, there can...

I figured it out. A reconfigure flushes the plan cache.