http://msdn.microsoft.com/en-us/library/aa259212%28v=sql.80%29.aspx

The above link explain what arithabort does.

It is not the cause of the problem but just a setting telling SQL what to do when it faces a issue.

If your shredding...

Why not use the pre execute and post execute events already present in SSIS ?

check the inputs being passed to the functions

A point I used to convince the people in my office was the .net developer mindset is not tuned to think of data but the actual logic being implemented. Therefore...

The functions looks like its meant to create a new unique value based on the input table name and the value returned from another function call within it. The output...

Neither, the term left and right are based on the order in which the table appears within the query.

ON a.id = b.id is the same as b.id = a.id and...

As I expected we all agree on the right way of doing things and the reasons. Unfortunately this is what was done and we faced an issue in LIVE. It...

Would you believe it If I told you we have all this in place , code travels thru 5 environments before it reaches LIVE ( not always tested 🙂 but...

Changing the collation will cause more problems than they fix. Besides its not even a real short cut to support unicode char set.

The right but painful way would be...

The scope of the temp table is within the session that created it.

For example if user 1 has created a global temp table ##temp then user 2 can access this...

Ive been using SqlPubWiz.exe with good results.

It might also be better to create a log on trigger and prevent users logging in once the trigger is enabled this way you don't need to rollback transactions and...

I think; before looking at the speed you need to understand the impact it has on the actual table definition.

Collations and datatypes etc will come into play when the temp...

http://www.sans.org/reading_room/whitepapers/application/sql-server-email-vulnerability-issues-prevention-strategies_1219

JOINS