Click here to Skip to main content
15,898,134 members

Comments by deadwood88 (Top 33 by date)

deadwood88 23-Nov-11 10:21am View    
No i havent. I will try the instructions in the link and report back with the results should any improvement occur.

Thanks a lot for your efforts.
deadwood88 23-Nov-11 9:43am View    
Both SQL2000 and SQL2008 are running on the same server and have the exact same database. When we want to insert data, SQL2008 shows much slower performance. This observation was noticed in our production facility.

I'm currently trying to simulate the same scenario on a local server here with 2GB of RAMs. I have both SQL2000 and SQL2005 installed on the same server and having the exact database. Queries on SQL2005 are also slower than those running on SQL2000. (im working with sql2005 rather than 2008 locally because it also showed slower performance in the production facility compared to 2000, and because i dont have 2008 available).

I havent configured memory allocation so its safe to presume that it is dynamic.
deadwood88 23-Nov-11 6:51am View    
No hardware differences whatsoever.

I havent changed disk RAID or the locations of Data\Log files\tempdb. should i do something about them?

any help would be highly appreciated.
deadwood88 6-Jul-11 10:52am View    
thank you. I didn't install any driver for the barcode reader. I just plugged it in and it worked jst like a keyboard would.
deadwood88 5-Jul-11 5:46am View    
Is there at least a way to differentiate them? I read somewhere that we can set the prechar or postchar value of each reader. But I couldnt figure out how to.