|
-
Mar 14th, 2010, 08:02 PM
#17
Thread Starter
PowerPoster
Re: SQL Server 2000 DateTime sorting issues
LOL @ saptor.
na, its just a client of mine. finished up the entire project but now need to deploy it and make sure it works just fine so they dont have to call me in future if the deployment didnt work. wanna make sure it works just fine.  again, never had these problems before.
the collation is the default one that is used with SQL 2000
@szlamany - after rebooting the deployment server, which has the slow DB, it initially took..... 2m 14s.
doing it again took 1m 2s
doing it again took 1 second
doing it again took 1 second
doing it again with the parameter change took 1 second
when the server is not being used for 2 minutes and I re execute the query, it takes 58 secs
?!
Last edited by Techno; Mar 14th, 2010 at 08:05 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
any chance of a regain? 
Reply With Quote