Recent content by micha123

Sorry... This is better: http://www.tpc.org/tpcc/results/tpcc_perf_results.asp?resulttype=all&version=5&currencyID=0 "A long life is when each day is full and every hour wide!" (A Jewish Mentor) M. [hourglass]

You can also rely your recommendations on the TPC results: http://www.tpc.org/tpcc/results/tpcc_results.asp?orderby=dbms "A long life is when each day is full and every hour wide!" (A Jewish Mentor) M. [hourglass]

I think that the major enhancement that will interest your managers is the performance improvements. From collegues I've heard of 10-20% improvement by only moving to SQL 2005. You can also read and read a lot of stuff about the enhancements in SQL 2005. For example...

Go to Start--> programs--> administrative tools---> services. Double click the MSSQLSERVER service--> Log On tab--> highlight "This Account" and use a local login credentials. Try to restart the service. "A long life is when each day is full and every hour wide!" (A Jewish...

Thank you guys for the tips! Denny, did you also see performance problems during the testing process? "A long life is when each day is full and every hour wide!" (A Jewish Mentor) M. [hourglass]

Well... It depends what kind of "errors" you are expecting to get... There are some errors that you cannot catch. Try the following and let me know if it helped: declare @Dummy tinyint Declare cursor... open cursor... fetch ... while @@fetch_status = 0 begin <Commands on cursor...

SQL 2000 or 2005? "A long life is when each day is full and every hour wide!" (A Jewish Mentor) M. [hourglass]

...And usually by re-doing all the transformations as I suggested - you would discovered that quicker... ;-) "A long life is when each day is full and every hour wide!" (A Jewish Mentor) M. [hourglass]

But if I make sure that there are no more DTS packages with ActiveX scripts (I will develop new packages using SSIS prior to the upgrade) and I will repair the problematic issues while testing the databases after the upgrade(i.e: the problematic views), do you still think that side-by-side...

Assuming that all the databases and applications were successfully checked by the Upgrade Advisor, what method would you choose to upgrade SQL SERVER 2000 Instance on cluster with 110 databases to SQL 2005: 1) Install 2005 on a new cluster machine, transfer logins, upgrade and test DB by DB and...

I would also try to recreate all transformations from scratch and see if it helps. "A long life is when each day is full and every hour wide!" (A Jewish Mentor) M. [hourglass]

Is the file local or is it on the NET? If it is not local - try to copy it locally and retry. "A long life is when each day is full and every hour wide!" (A Jewish Mentor) M. [hourglass]

The target memory is 3913259. I am not sure if the SAs rebooted the server. They were suppose to but it might be the problem... I guess I will be back if they did... [bigglasses] "A long life is when each day is full and every hour wide!" (A Jewish Mentor) M. [hourglass]

Have the same problem. How did you fix it? Thanks... "A long life is when each day is full and every hour wide!" (A Jewish Mentor) M. [hourglass]

You are right about that. I found this in a white paper: "Unlike SQL Server 2000, in SQL Server 2005, all service accounts that will administer SQL Server, SQL Server Agent, Full-Text Search, or Analysis Services must be added to a global domain group which is then added to the local...