Search results for query: *

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...

Hi Catadmin, Thank you very much for the detailed answer! Is it 2000 or 2005 you are talking about? I have done a lot of SQL 2000 clustering (so I am able to answer questions about that...:-)), but none in 2005. Did someone do that? Is it the same thing as in 2000, just using the memory...

Hi Guys, I was looking for info about the active/active model for SQL Server 2005 on Windows 2003 cluster. All the documentation I found in the last two days of research did not give me any answers. I just need a diagram or a paragraph explaining how it works. Is it like the active/active model...

I am trying to execute DB2 UDB Stored Procedures directly from Reporting Services. The DB2 is on AS/400. I've tried to run this with the following providers: * Microsoft ODBC for DB2 * Microsoft OLE DB Provider for DB2 * IBM ODBC for DB2 * ODBC and OLEDB for iSeries When I am running DB2 UDB...

Is the ';' part of the value? If it is - you are doing fine. You are using SQL SERVER login (/U /P). I imagine that the user and password are correct. You can validate them in query analyzer. "A long life is when each day is full and every hour wide!" (A Jewish Mentor) M...

Please try the following undocummneted command: dbcc sqlperf(logspace) you can insert the results into a table on a regular basis and investigate them automatically. The size of your transaction log depends on the size of your transactions between database/transaction log backups (depend in...