Maybe a time-out error?

Time to tune that query 🙂

A job cannot be run multiple times at once.

An easy one, thanks Steve.

Errors and/or warnings probably?

cbrammer1219 (10/13/2014)

---

Yes it would, be however the data within these table is a lot, some more than 17mb, my lead advises not to load all of this as it would...

Bharatvip (10/13/2014)

---

All this is new to me and I was not sure I understood: "the data for most is memory-only, no persistence.".

Does this mean the data needed for the...

Time to take a look at the execution plan. Remove the TOP and get an estimated execution plan.

Maybe you need some indexes to speed up the query.

How many rows are we talking about here?

How many flat files (aka how many joins)?

You'll learn a lot more if you try to write the query yourself.

Take a look at the following functions:

CHARINDEX

SUBSTRING

1. Look for the string // (of http://). If you find it, the character that comes after it is your starting position. If you don't find it, the starting point...

Bharatvip (10/12/2014)

---

I am trying to do performance tuning on a database that is in production and that I do not have access to. I can be given a backup copy...

The following columns are missing in the CTE:

MessergebnisAlpha, MessunsicherheitDefault, testCode, Probennummer, [Parameter] and isDisplay_LOQ.

Also, in the CTE, you have the following CASE expression:

CASE WHEN (CONVERT(FLOAT,REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(LTRIM(RTRIM(pt.limitOfQuantification)),CHAR(13),''),CHAR(9),''),CHAR(10),''),'<',''),'*',''),' ',''),',','.')) * 100

>CONVERT(FLOAT,REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(LTRIM(RTRIM(pt.limitOfQuantification)),CHAR(13),''),CHAR(9),''),CHAR(10),''),'<',''),'*',''),' ',''),',','.')) *...

Ah ok. So basically if the gap between two timestamps is bigger than 15 minutes a new group should be started.

This is a typical gaps and island problem.

Itzik has a...

OK. On what decision are the first three rows grouped together and the last two rows grouped together?

It seems there is a ) missing that closes your CTE.

Where does it need to be?

After " AND pt.testId = t.TestId

AND pt.isDeleted =...