Our dba told me today that by having views that reference column and table names that are not the same case as the ones in the actual tables there is a performance hit due to increased buffer sizes. Has anyone ever heard of this, I googled it and only seemed to get
I have a table which has a unique index on two columns. Sometimes a insert sproc tries to append values which violate the unique index. I want the sproc to continue trying to insert other new rows, but instead it fails with an error "cannot insert duplicate key row". I want the
Some time back Lee "Mr Tea" Tudor posted his sqltrace to this newsgroup. I am now glad to announce that I'm hosting it on my web site. You find it http://www.sommarskog.se/sqlutil/sqltrace.html. sqltrace takes an SQL batch as a parameter, sets up a trace filtered