There are other factors that govern this as well.  In SQL Server, ANSI settings control the "storage" part of the trailing space and that is done at the time of...

There is an excellent white-paper from Quest on this.  Go to http://www.quest.com and download the white-paper.  It has all the detailed steps on how to do performance monitoring and...

--to get a list of triggers in the database

SELECT NAME FROM SYSOBJECTS WHERE XTYPE = 'TR'

GO

--to look at the trigger body

SP_HELPTEXT Trigger_Name

GO

--to drop the trigger

drop trigger trigger_name

and to modify, just...

You are moving the entire table. You can try the pass-through query syntax using openquery which will offload the query processing on the iSeries side - however, it will still...

Could be a DNS issue...can you ping the machine ?  If you are connecting to the default instance, you can also try doing a telnet to the machine on port...

Check out the tool from AdventNet - it will do 60-70% of the work with the remaining being done by your database developers/DBAs:

http://www.swissql.com/products/sqlserver-to-oracle/sql-server-to-oracle.html

Run with trace flags 1204, 1205 and 3605 on and look at the deadlock trace file that gets generated.  It will give you an idea about what is going wrong with...

Excellent link.

INet's driver might be better for this - the last time that we compared the performance of this with Microsoft's JDBC driver the MSFT dirver performed very poorly in load...

It's a pretty vast topic.  Look for "parallel queries" in SQL Server Books Online.  It works exactly as it does in Oracle but there are differences in terms of configuration...

1) Why is there a trigger to update a column to getdate() ? Why is that not being handled in the update statement itself ?

2) Also, you mentioned in #4,...

That logic is to be handled by the client application - the uniqueness constraint in the database prevents any data integrity issues and will return a 2601 error if a...

You can try Adventnet's tool:

http://www.swissql.com/products/db2-to-sqlserver/db2-to-sql-server.html

Such tools typically do 50-60% of the work for you and still require a lot of input from people who know what DB2/AS-400 and SS2k...

Blocking locks and deadlocks are different things.  If you are getting deadlocks, you can enable the trace flags 1204, 1205 and 3605 to get more information - that way the...

Spotlight works out pretty well actually - it's true that Quest has other tools for Oracle and DB2 which are very popular but Spotlight has been around for a very...