Yes it would look like:

Select [flag ='y' ].some_data from [where] [flag ='y' ]

Nope we had tried statistics and I updated all stats with fullscan. Still no effect.

I'm done looking at the SQL Server side. I've looked at the code and we definitely have some inefficiencies where we are executing the query more than is necessary....

I did a test on the prod box. I shut down the SQL 2000 instance so that all the machine resources would be available to the SQL 2005 instance...

Actually that's what puzzled me. BOL says that GO is not a T-Sql command but a command recognized by Sqlcmd, Osql, and the SSMS Code Editor. It also...

Here's my interpretation of what happens. Note if you select and execute the lines by themselves you get different results than you do if you combine them into a...

Note the USER_ID function will also be removed in a future version according to the SQL Server 2005 Books Online.

Great interview Steve.  I'm looking forward to the others!

Grasshopper,

Ahh! I couldn't see it for anything.  What I meant was not what I typed.  I wanted the difference like what follows:

Create trigger dbo.bkiTriggerTest_Instead

      on dbo.bkiTriggerTest

      INSTEAD OF INSERT

   AS

  ...

Gopal (ext5qxt)

If I test for @@ROWCOUNT equal to zero, then I won't execute the second insert when there are dups.  But I want to execute both statements because there may...