Just put all your code in 1 (n) sp(s) and call the correct sp, that makes only 1 line of code in your application and the clutter disappears.

Nothing wrong with...

They should all be local temp. Why do you drop permament tables? How do you expect that code to function if...

You're welcomed! 😉

http://www.sqlservercentral.com/Forums/Topic939436-359-1.aspx#bm941314

GSquared (11/14/2011)

---

Brandie Tarvin (11/14/2011)

---

L' Eomot Inversé (11/14/2011)

---

Brandie Tarvin (11/14/2011)

---

Especially when DBAs are forced to use vendor databases over which they have little schema control. Don't beat up the people who...

Yes you can, but that often has the cost of poorer performance.

What do you need to accomplish (business requirement side of things)?

SQLRNNR (11/14/2011)

---

Brandie Tarvin (11/14/2011)

---

I get that. I do.

It just seems lately that there are a lot of people on this forum (including long-time posters like us) have been jumping on...

T'was clear enough without the edit! 😉

GSquared (11/14/2011)

---

Ninja's_RGR'us (11/14/2011)

---

GSquared (11/14/2011)

---

Ninja's_RGR'us (11/14/2011)

---

GSquared (11/14/2011)

---

SQLRNNR (11/13/2011)

---

I find the practice of prefixing with tbl_ just a waste of 4 chars in a table name. It would be funny if...

Well you can buld the columns name like that and then swap them in the presentation. I still don't see the issue with that option.

Using CTE instead of derived table.

;WITH CTE

AS (

...

Set max memory for sql server and make sure to leave 1-2 GB for the OS.

Aside from that, % of memory used is insignificant as a perf metric.

Can't help without seeing the code.

And since this is most likely mdx, can't help at all.

Has to be dynamic sql.

Or pivot in the front end.

Or pivot in sql then use front end to display the column name. Which you can dynamically concatenate sql server...

Read that whole thread. Especially the end.

http://www.sqlservercentral.com/Forums/Topic1154939-146-1.aspx