"if table A has null value raise error 'please enter your ID'"

Wouldn't this be the same as your post from here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=354363

except that you would want to stop the UPSERT...

Wow, sorry about the multi-post.  My PC blinked on me and it posted multiple times as I was still typing. 

Anyhow, if my above suggestion does not help, please post...

Well, what are you expecting to get back?  For starters, it appears that you have a typo in your @write tally in the line: Select write =@write + 1.  Shouldn't...

Well, what are you expecting to get back?  For starters, it appears that you have a typo in your @write tally in the line: Select write =@write + 1.  Shouldn't...

Well, what are you expecting to get back?  For starters, it appears that you have a typo in your @write tally in the line: Select write =@write + 1.  Shouldn't...

Well, what are you expecting to get back?  For starters, it appears that you have a typo in your @write tally in the line: Select write =@write + 1.  Shouldn't...

There are a few differenct licensing models to choose from depending on your needs.  SQL Server 2005 licensing info can be found here: http://www.microsoft.com/sql/howtobuy/default.mspx

As far as your expected growth,...

Your query (as posted) cannot possibly return the error in your post.  This is a very straight forward error and there must be a sub-query...

Make sure your columns in dbo.Database_Logins are big enough to hold the result set from sp_DatabaseLogins.

SQL Server is designed to grab as much memory as it can and not release it.  If you want to limit how much memory SQL Server can use, set you...

UNION removes duplicate rows.  Use UNION ALL if you want the duplicates to remain.

'Unless the drive array was being hammered from another server [File or Exchange]; I never checked that.'

Is this on a SAN?  If so, you want to make sure that your...

Are all inserts slow?  What about updates?  Is your t-log the only thing using the mapped array?  Is it on a SAN?

Are you using SQL Server 2005?  Your post is in the SQL Server 7,2000 T-SQL section....

Here's the cost w/o the CTE:

SELECT Cost

FROM #CostHist ch

    INNER JOIN (

                SELECT s.SaleID, s.Item,...

Can you post the full table DDL including the indexes and the execution plans for both queries?