It might be the way the query is compuiled inside your SP. If number of rows in the perm table is small, then indexes do not matter anyway. You may...

UPDATE Xaction

SET FaxReqPhoneNum = CASE when x.FaxReqPhoneNum = 0 then v.FaxReqPhoneNum

END

, InternationalPhoneFlag = CASE when x.InternationalPhoneFlag = 0 then v.InternationalPhoneFlag

END

FROM XactionVRU v

JOIN Xaction x

ON v.SSNum = x.SSNum

AND...

Ladies and Gentlemen,

Please do not be so serious. This article is entertaining - that's it. If a junior (or "SENIOR") DBA should take it seriously, the worst thing that could...

If you are calling one procedure from another, make sure you handle transactions properly in both procedures. Do not nest transactions; do this:

SET @local_transaction = 0

IF @@TRANCOUNT = 0

BEGIN

...

My rule is never use cursors.

Well, there are rear exclusions but this is not the one. It is healthier for your production environments to forget completely cursors ever existed.

I...

My suggestion is NOT to use cursor nor an ActiveX.

First, load your data into a load table from the file.

Second, run a scrubbing SP that would bring your...

Use code to insert text data into your table. Do not use Enterprise Manager.

Do not use regular SQL INSERT, UPDATE, etc. The following commands should be used:

READTEXT, TEXTPTR, WRITETEXT,...

I would not recommend creating a column and dropping it dynamically. There is no elegant solution to this request. You could maintain the last used number in something like tbl_system_parameter...

Do you have a proper error handling inside SP? Do you check IF @@ERROR <> 0 after each SQL statement and then GOTO error_handler? Did you put IF @@TRANCOUNT >...

I doubt there is a way. However, if you execute the whole script couple times in a row, it should run with no errors the second time (unless you drop...

I understand the points about OOP made in the previous message. In the same time, SQL language itself does not support OOP.

A column named ID will be used without...

In fact using a user-defined function that returns a table is a very good alternative to a view because it replaces functionality of a parameterized view not supported by SQL...

I think the result may depend on how you will be using the view. If it is a part of a query that is not very trivial, I would not...

I always use singles, not plurals, for table names: tbl_employee, tbl_employee_history.

I would not recomment naming column as just Id. First of all, it is a reserved word (it changes color...

Just change your sample query to the following:

SELECT Column1 FROM Table1 WHERE Column2 IN

(SELECT Column2 FROM Table2 WHERE Column3=@Value1

UNION SELECT 'mystaticitem'

)

AND Colum4=@Value2