-Kore
Rob
<[EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]>
om> cc:
Subject: Re: OT: migrating to SQL Server 2000
03/01/2004
03:40 PM
Please respond
to cf-talk
Did your indexes come over ok? There is a setting somewhere on 7 I
believe when moving data if you do not say you want indexes to go they
wont. That could impact performace (more on selects I would imagine).
Anyway I have done at least 3 SQL7 -> SQL2000 and there were a few minor
problems (and very obscure syntax changes) but not much to write home
about.
On Mon, 2004-03-01 at 13:16, brobborb wrote:
> Is there a HUGE difference between SQL 7 and SQL 2000??? Because 2000 is
just running really slow and we can't figure out why. Is there a
difference in syntax or something? On SQL 7 a multiple insert query (400
inserts) finished in 400ms. in 2000, same query, but in 7 SECONDS!!!
>
> i've google some information and it seem others have come across this
problem, but we could not fix ours to work correctly. I hope this is
fixable :(
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
