There should be no difference between Query Analyzer and your Perl script. Are you sure there is no condition in the trigger that is not satisfied?

If the ODBC driver doesn't do the job, you could export to a csv and do the import from an agent in Notes that you've scheduled.

Don't know about encryption for SQL Server, but you could use a VPN tunnel to make sure all data passing is encrypted.

If you use the ALTER TABLE technique, be aware that any other inserts taking place (by another user, for example) will also not fire the trigger!

I am afraid I can't really help you on this. We have used UDT's in some projects (using VB.NET), but we did not have a direct link to the type...

To get a list of all records that do not have matching records, use the following query:

SELECT dlo.DIVISON_CD, dlo.GROUP_TXT,

       SC60.DIVISON_CD...

This is normal behaviour for a trigger.

Inside the trigger, you have a 'inserted' and 'deleted' table. These tables contain the complete set that was changed during the update ('deleted' contains...

I don't think you can do that.

A work around is doing the calculation in the from clause. Something along the lines of

SELECT Calc_Field, <other fields>

FROM (SELECT <other fields>, <Calculated Field>...

You can do this in one query, without the need for temp tables :

SELECT H.sh_serial_no,

       Mini.Invoice_Date, Mini.Meter,

   ...

Antares,

I can agree with what you are saying in your post. A 'simple' processing UDF should not incur a large overhead.

However, I'm not clear on how the performance is affected...

Or continue to use the join syntax as in:

UPDATE Table1

SET Table1.NumOfImages = temp1.NumOfImages

FROM Table1

 INNER JOIN

     (SELECT KeywordID, count(*) as NumOfImages

 ...

I tend to keep away from UDF's if at all possible. It is a great feature to reuse code, but it can kill performance as you noticed.

One place we 'often'...

Jeremy,

If performance really is too slow, drop the Userdefined functions and code everything directly in the SQL Statement.

If you want, you can testdrive, only doing the updates of the function...

There is another 'SQL language' around that is designed specifically for querying cubes. It is called MDX (Multi-Dimensional Expressions, if I recall correctly). You can use that to query your...

You can use the BCP command line utility to import and export data to a (formatted) file. Not exactly T-SQL of course, but using xp_cmdshell it is possible.

I think you...