dreamslogic (6/13/2009)

---

Hi Steve - Here are the choices

Create a new View

Use a cursor and store the data in a temporary table

Create an Indexed View

Create a User Defined Function to return...

herald_singh (6/13/2009)

---

Guys I need help. I'm wondering why did my mdf file grew bigger after I did the following:

1) Altered data types from nvarchar/ntext to varchar. Also reduced length as...

I haven't gotten anything yet either.

Jeff Moden (6/13/2009)

---

You're absolutely correct and preaching to the choir. I should have just said that it was O(n²) and left it at that because that would have been...

Hmm, before I jump into this any deeper let me ask: what would we be trying to accomplish by this? What shortcoming of SSC would we be fixing? ...

Uh, OK folks. Yes, I did know that when created in a top-level request, the temp tables scope is attached to the session instead of the request. (And...

Jeff Moden (6/12/2009)

---

RBarryYoung (6/10/2009)

---

Jeff Moden (6/10/2009)

---

If you strip away all the small stuff that won't impact the result much when the numbers get really big, you end up with O(N²/2)....

Mmm, not really my cup of fur.

Jeff Moden (6/12/2009)

---

Steve Jones - Editor (6/8/2009)

---

We have debated about some of the features in Stack Overflow here, especially as they've gained a lot of popularity. I'll post a few...

Why? Are my pork chops showing? :w00t:

homebrew01 (6/12/2009)

---

I think the original version of SQL 2005 did not let you script one file per table, but everyone should be on at least SP2 by now.

Is there a...

You know, I've always wondered why the #Temp tables that we create in SSMS (or QA) don't get destroyed when the batch/request ends. Shouldn't they run out of scope...

Thanks Doug, I got it fixed. That link that you provided did not have my answer, but did provide the clue that I needed to figure it out. ...

epriddy (6/12/2009)

---

Typically, temp tables only last for the length of the session. My understanding is that when you exec sp_[name] then it's essentially running the SP outside of your...

Yes, that is what it will do. I have it right...