Based on this info, I really don't think you have a problem. SQL Server will use as much memory as it needs to do its job constrained by the...

Based on this, I don't think you have a problem.

Couple of questions however. What version of SQL Server 2005 are you running (including CPU type, x32 or x64), how...

Nice to hear, thanks for the feedback.

Other than the above are you experiencing any other problems?

setiv (9/21/2009)

---

Originally the question was a breadboard model of the program,

Instead of about a ready product.

Some features of work of a breadboard model are found out.

On seen sql2008 with c#...

You didn't provide the error message you are getting, but I can see the problem. You can't use variables in the SELECT INTO the way you are attempting. ...

Good idea, just one problem. I...

Grant Fritchey (9/18/2009)

---

Lynn Pettis (9/18/2009)

---

Grant Fritchey (9/18/2009)

---

Lynn Pettis (9/18/2009)

---

Grant Fritchey (9/18/2009)

---

Lynn Pettis (9/17/2009)

---

Just an FYI for the denizens of The Thread, next Tuesday I have another article being republished here...

Next question, annual or monthly salary?

It always amazes me how quickly others will join a topic when asked. This site is just awesome! 🙂

Grant Fritchey (9/18/2009)

---

Lynn Pettis (9/18/2009)

---

Grant Fritchey (9/18/2009)

---

Lynn Pettis (9/17/2009)

---

Just an FYI for the denizens of The Thread, next Tuesday I have another article being republished here on ssc as well....

Building on this, empid isn't even in the index, so sounds like a good possibility for a table...

Grant Fritchey (9/18/2009)

---

Lynn Pettis (9/17/2009)

---

Just an FYI for the denizens of The Thread, next Tuesday I have another article being republished here on ssc as well. Keep an eye...

Anyone else want to add anything here?

That may be what you are looking for, but don't restrict yourself to just that. There may be other things that maybe better than an indexed view. Leave...