Viewing 5 posts - 1 through 6 (of 6 total)
Barry is my hero today. Thank you for pointing that out, and what a trivial explanation for a weirdo problem.
December 15, 2008 at 2:48 pm
Well I have learned a few things about SQL Server in the last few hours. Two things which come into play here.
One: 622 is the number of index...
December 15, 2008 at 1:46 pm
Garadin (12/12/2008)
I was wondering about the performance of the rownumber solution. The way you were doing it seemed really inefficient at first glance... inserting a ton of data, then...
December 15, 2008 at 7:29 am
Garadin (12/12/2008)
Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86) Jul 9 2008 14:43:34 Copyright (c) 1988-2008...
December 12, 2008 at 1:56 pm
That does seem correct. And you're on 2K5? All our 2K5 (9.0 SP2 to be exact) databases exhibit this error.
December 12, 2008 at 10:41 am
Viewing 5 posts - 1 through 6 (of 6 total)