Viewing 15 posts - 7,516 through 7,530 (of 18,923 total)
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?
November 29, 2010 at 5:25 am
Jeff Moden (11/26/2010)
Ninja's_RGR'us (11/26/2010)
Jeff Moden (11/26/2010)
rs80 (11/26/2010)
Gail, why would you get duplicate rows?
Non-techincal answer: When dirty reads are allowed, it is possible to read a row and then have...
November 27, 2010 at 7:08 am
Jeff Moden (11/26/2010)
rs80 (11/26/2010)
Gail, why would you get duplicate rows?
Non-techincal answer: When dirty reads are allowed, it is possible to read a row and then have someone update that...
November 26, 2010 at 2:32 pm
CirquedeSQLeil (11/25/2010)
Ninja's_RGR'us (11/25/2010)
How the heck did so many people could possibly imagine that Misspelling is an issue in a SPOKEN podcast :w00t:.Intriguing isn't it.
Maybe they're just making fun of the...
November 25, 2010 at 10:05 am
MTY-1082557 (11/24/2010)
How long does it take to do a select into?
it takes 2 seconds
How long does it take to insert in the base table if you...
November 25, 2010 at 7:10 am
How the heck did so many people could possibly imagine that Misspelling is an issue in a SPOKEN podcast :w00t:.
November 25, 2010 at 5:37 am
marcinSkorupka (11/25/2010)
At the moment we are using sql server 2005.
I know that in sql server 2005 SP2 there is data compression for decimal/numeric...
November 25, 2010 at 5:33 am
MTY-1082557 (11/24/2010)
How long does it take to do a select into?
it takes 2 seconds
How long does it take to insert in the base table if you...
November 24, 2010 at 2:28 pm
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...
November 24, 2010 at 11:46 am
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.
November 24, 2010 at 11:36 am
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...
November 24, 2010 at 11:00 am
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...
November 24, 2010 at 9:35 am
Geoff A (11/24/2010)
GSquared (11/24/2010)
Ninja's_RGR'us (11/24/2010)
GSquared (11/24/2010)
November 24, 2010 at 8:52 am
Kwisatz78 (11/24/2010)
How does a web front end not qualify for a device CAL when all external users will be...
November 24, 2010 at 8:41 am
GSquared (11/24/2010)
Per-processor is how most multi-user installations are done. CALs are mostly useful to very small shops with a small number of people accessing the system.
Sorry to highjack this...
November 24, 2010 at 7:01 am
Viewing 15 posts - 7,516 through 7,530 (of 18,923 total)