I got all my info from this site :

http://www.gotreportviewer.com/

I've never done it that way (not even sure it's possible).

Assuming the address looks something like this :

http://reportServer/reports/...

How is someone going to be able to resolve that name? ...

Maybe a bit young to see 4-5 billion people killed...

How are you trying to access the reports in ASP .NET? (Direct URL or reportviewer control)?

What is the authentication mode of the users on the site?

Jeff Moden (11/26/2010)

---

Ninja's_RGR'us (11/26/2010)

---

Jeff Moden (11/26/2010)

---

Non-techincal answer: When dirty reads are allowed, it is possible to read a row and then have...

Jeff Moden (11/26/2010)

---

Non-techincal answer: When dirty reads are allowed, it is possible to read a row and then have someone update that...

Maybe they're just making fun of the...

MTY-1082557 (11/24/2010)

---

it takes 2 seconds

How long does it take to insert in the base table if you...

How the heck did so many people could possibly imagine that Misspelling is an issue in a SPOKEN podcast :w00t:.

marcinSkorupka (11/25/2010)

---

First of all thank you for your opinions

At the moment we are using sql server 2005.

I know that in sql server 2005 SP2 there is data compression for decimal/numeric...

MTY-1082557 (11/24/2010)

---

it takes 2 seconds

How long does it take to insert in the base table if you...

How long does it take to do a select into?

How long does it take to insert in the base table if you disable all NC indexes?

Does you have triggers, foreign...

How long does it take to run the select alone (without insert)?

5 mins for a couple million rows is not lightning fast but it's not crawling either by most standards.

Assuming SQL 2K8 Enterprise or SQL 2K8 R2 Standard + , just turn on compression.

You'll get the same IO boost with a very small CPU hit and zero change...

So the problem here is that the server becomes unavailable for 4-6 minutes whenever you do this?

You could do it in batches of 30 - 50k rows which would lock...