I usually start breaking down at 300, then...

if you do if not page.ispostback

can it solve your issue?

I know it's hack but that's all I can offer at this point.

All I know from reportviewer control I learnt there...

What do you mean by offline backup??

AFAIK, if somehow you're able to bring back the db online you'll be able to take a log backup to do the restore up...

Already there. No more than 500 posts / day.

yes that's a tried limit!

What is loading twice? The report or the asp page?

Why do you think the memory is the problem??

Do you run anything clr or xml on that server? That takes ram outside the max settings and you can't really...

GSquared (11/11/2011)

---

Ninja's_RGR'us (11/11/2011)

---

Brandie Tarvin (11/11/2011)

---

Ninja's_RGR'us (11/11/2011)

---

Roy Ernest (11/11/2011)

---

Congrats Brandie. Wonderful job. 🙂 You can stop...

Brandie Tarvin (11/11/2011)

---

Ninja's_RGR'us (11/11/2011)

---

Roy Ernest (11/11/2011)

---

Congrats Brandie. Wonderful job. 🙂 You can stop working as...

Add this code just before the first CTE in my code.

--Quick test to see how long this runs with 100K rows

INSERT INTO @Table (URL)

SELECT TOP 99990 URL FROM @Table...

Roy Ernest (11/11/2011)

---

Congrats Brandie. Wonderful job. 🙂 You can stop working as a DBA and...

My fav signature from Lowell =>

Lowell

--------------------------------------------------------------------------------

--There is no...

Dev (11/11/2011)

---

Ninja's_RGR'us (11/11/2011)

---

schumichen (11/11/2011)

---

the table contains more than 100.000 urls....with every ending that is possible...

maybe its better to make a new column with the domains ?

like

id,url,domain

so would...

They won't be ramdom either.

You want RAMDOM order...

schumichen (11/11/2011)

---

the table contains more than 100.000 urls....with every ending that is possible...

maybe its better to make a new column with the domains ?

like

id,url,domain

so would that be easier to...

Dev (11/11/2011)

---

schumichen (11/11/2011)

---

the table contains more than 100.000 urls....with every ending that is possible...

maybe its better to make a new column with the domains ?

like

id,url,domain

so would that...