Too big to optimize on a web site.

Give or take a little bit of luck this should take anywhere between 8 to 40 hours to tune (depending on...

For the restores :

http://www.red-gate.com/products/dba/sql-virtual-restore/entrypage/painkillers

NEVER shrink the log files. Unless it was uselessly bloated by the deleting of 50% of the db. You say you are doing that...

If you truncate to delete data 5 years and older and then never keeping data beyond that period then a shrink can make sense (pretty much the only thing that...

Jeff, where can I apply? :w00t:

If you don't have anything setup before the problem to have a baseline the counters won't help you much (if at all).

Check this out, it'll give you 1 month of...

Very far on...

Daily sounds really long to me.

Maybe take 1-2 days to run the code manually and then see how big / fast the cache gets full again.

This code should run under...

Gianluca Sartori (8/2/2011)

---

Ninja's_RGR'us (8/2/2011)

---

Gianluca Sartori (8/2/2011)

---

Ninja's_RGR'us (8/2/2011)

---

If you take out the 55 euro for the cell phone (which I don't have) it comes considerably under my bill 134 VS...

You probably have a table linked to dataset 1 and trying to drag fields from data set z.

johnsonchase7 (8/2/2011)

---

Thanks guys, I assure you it was not an exam. It is actually a self motivated project I am working on. I would have appreciated the answers even if...

Gianluca Sartori (8/2/2011)

---

Ninja's_RGR'us (8/2/2011)

---

If you take out the 55 euro for the cell phone (which I don't have) it comes considerably under my bill 134 VS 165 Can$.

What limits...

jcrawf02 (8/2/2011)

---

SQLkiwi (8/2/2011)

---

I have a prepay phone. It has a black-and-white screen, can make and receive calls (apparently) and also send...

SQLkiwi (8/2/2011)

---

I have a prepay phone. It has a black-and-white screen, can make and receive calls (apparently) and also send and...

Gianluca Sartori (8/2/2011)

---

Ninja's_RGR'us (8/2/2011)

---

Gianluca Sartori (8/2/2011)

---

If I have to take the cell phone into account, I'm paying something like 50/60 Euros a month.

You add the ADSL line and there you...

GilaMonster (8/2/2011)

---

Koen Verbeeck (8/2/2011)

---

I pay about the same. But I got a *censored* download...