Grant Fritchey (1/20/2011)

---

We had a similar situation. A procedure (with a 76 table join) that was called hundreds of times in an hour. It hit so many tables and the...

Agreed here. There's no way out of this. You either pay for a license or pay for time.

The only question here is how much is the license compared...

bitbucket-25253 (1/20/2011)

---

mwk (1/20/2011)

---

I have a database that is at the 4096MB limit. I already backed up

the database, but just want to make room by deleting the older records.

Is...

I don't have a ready made answer for you.

I would start by familiarizing myself with sys.dm_exec_cached_plans.

Hopefully someone else has a more usable answer to give you.

BTW afaik there's no way to force to plan to stay there (maybe I'm wrong).

The server manage its ram as it sees fit and there's no much you can...

Exec cache would not be my first check here.

Assuming some sort of 9 to 5 env... everybody starts working at the same time so the first few minutes are usually...

Well yes you can avoid...

So can you upgrade to express 2008 R2?

You'll have 10GB instead of 4.

What I used to do is create a shared drive.

Then make a bat file that ran each morning or on demand to get the latest version of the application (make...

Are you on SQL server express?

If so you can always upgrade to 2008 R2 and enjoy a 10 gb limit instead assuming you can't afford a license at the moment.

What was the payscale for that job?? :w00t::-P:hehe:

And now high jacking my own thread for the 2 time.

I have bids installed in french. I'm sick of not getting the info about error messages because I don't...

Ferguson (1/20/2011)

---

It's...

I can give a hint from my own "limited" experience. I am a consultant and yet I've only interviewed 5-6 times in my life for contracts (most of them...

Wow I'm so glad I found the "wrong" posting for this job. This thread should be called The Thread II.

Amazing feedback from everybody.

Any to pin it in the...