rob (7/17/2009)

---

Oooooooh so all you have to do is OWN a piece of paper stating the CAL's are yours, not actually apply them to the server so that it lets...

jcrawf02 (7/17/2009)

---

Lynn Pettis (7/17/2009)

---

I try to work 3 or 4 tournaments a year. Depending on the tournament, that can be anywhere from 2 days to 7 days long. ...

I have to agree with Brandie, obviously SQL Server doesn't need all of the available memory or it would take it, potentially starving the OS if it needed all of...

Short of a backup file, I know of no way to recover a database that has been dropped.

Why don't you have a backup of a production database? Setting up...

I was also looking at your code, what version of SQL Server are using? I'm guessing that it is SQL Server 2000, not SQL Server 2005. If it...

Blazix Marler (7/17/2009)

---

thanks for the info on the datestamps.

But query is taking lot of time to run , can it be tuned to run more faster.The query is

select s.domainid,d.domain,s.urlid,u.url,s.applicationargumentid,a.application_argument

from...

rob (7/17/2009)

---

So what your saying is that you cant add extra User CAL's to an existing server that I must Install the server software to start with, with more licences...

You still haven't answered Brandie's question. Are you having performance issues or are you just wondering why the extra 1.5 GB of RAM isn't getting used?

jcrawf02 (7/17/2009)

---

Lynn Pettis (7/16/2009)

---

Well, I have been enjoying my time off work, but I haven't been doing much soccer officiating so far. Tournament started on Monday and today was...

Maxer (7/17/2009)

---

From what I have read and how I am reading it each developer working / connecting to SQL Server needs a dev license.

After that it gets a BIT fuzzy.

Say...

Well, I have been enjoying my time off work, but I haven't been doing much soccer officiating so far. Tournament started on Monday and today was the first time...

Lynn Pettis (7/16/2009)

---

Could be me, but why do I get the feeling that it isn't the transaction log that was growing, but the backup file. Could it be that...

Could be me, but why do I get the feeling that it isn't the transaction log that was growing, but the backup file. Could it be that the daily...

skailey (7/14/2009)

---

While I appreciate the reasoning for why you would like certain questions posted this way, I believe it is overkill for my question. I have 2 tables. ...

While you are figuring out how to post the execution plans, please post the DDL for the table(s) and your code. That will give us something to start with...