One other thing it could be is missing indexes, the additional I/O load on the disk can cause high CPU. Have you checked the activity of the disks while you...

It can also make life easier for developers if all the primary keys are integers, it's a bit like having a design pattern that will make coding faster and more...

Just a thought, but instead of

IF NOT EXISTS(SELECT * ... or IF EXISTS(SELECT * ... , why not use Top 1?  all you need to know is only 1...

I think you mean "surrogate" key, as there is no identity column on your table. I would use a surrogate identity column as the PK so create the table like...

Performance Tip: The conditional behavior described for the MERGE statement works best when the two tables have a complex mixture of matching characteristics. For example, inserting a row if it doesn't...

I found some code someone else has written to...

Yes, it can retrieve partially updated records and if a page-split is happening it can return duplicate rows.

Best to only be used on data that is not being updated and...

It makes no difference.

That's pretty interesting. Looks somewhat similar to Eirikur's but a few differences. The one thing I am not a fan of is that it has the same major miss...

You can rewrite the SQL as this:

IF EXISTS(SELECT *
            FROM #GRatings
     ...

Just break up the statement so you are adding to @SQLSTRING several times.

SET @SQLSTRING = N';WITH CTE AS ' +
       ...

You could try this STRING_SPLIT function I'm in the process of writing and give me some feedback.

It's like SQL Server's STRING_SPLIT function but will work with SQL 2012 and...

Your query would be more efficient if you used a cursor to select distinct ref_nr_vertrag from table tbl_111_aed2_umhaengen_Verträge. Like this:

DECLARE @Vertrag AS int= 1
DECLARE @myCursor cursor
SET @myCursor...

If you have an index on the table:

DECLARE @Planning_Proposal_Temp TABLE (object varchar(10), dateFrom datetime2, dateTo datetime2
           ...

• This reply was modified 6 years, 10 months ago by Jonathan AC Roberts.

I think it can be done with a recursive CTE:

;WITH rCTE AS
(
    SELECT a.object,
          ...