Thanks for the feedback Bit.

cannot see any reason why you couldn't do this same thing with TRY..CATCH blocks.

The only way that I know of to insure...

Jeff Moden (4/7/2008)

---

I...

Sergiy (4/6/2008)

---

I once improved responce time of the query from 10 s to under 1 s just by replacing NOT IN with NOT EXISTS.

Don't remember exactly how many rows were...

I do not believe that you can do this with an ALTER TABLE.

The SOP for this kind of table change is to create a new table with its...

Good one. 🙂

I was serious about my Uncle though, he really did do all of that stuff.

Jeff Moden (4/6/2008)

---

If I need to insert constants, I use INSERT/SELECT... if I need to insert more than one row of constants, I use INSERT/SELECT/UNION ALL... I can't actually remember...

Any other Jobs?

delta dirac (4/6/2008)

---

yeah, i think it's a good way to go, sth. like confusingly renaming everything like obfuscation,(15 years of electronics engineering 10 years of high level math and physics...

If you can wait until Sql2005, than I would recommend a very similar approach, except use asynchronous triggers writing to Service Broker queues. This will take care of most...

check your maintenance plans for other activity. Things like rebuilding your indexes can have exactly this effect.

If you mean "mixing VALUES clauses with SELECT clauses" in an INSERT statement, then...

Heh, you should meet my Uncle. He taught me to program when I was 13, but he learned computers as an electronics instructor for the Army Air Force when...

*sigh*

Folks, the solution to this problem is the same as what Microsoft uses for its own database-oriented products like Sharepoint:

1) Split the implementation between Client software & DB structures.

2) Name...