Garadin,

you forgot to do FREEPROCCACHE.

Without it you just read the same recordsets cached in memory again and again.

No actual data accessing happens in your test.

From logical point of view COALESCE...

Your problem is UNION in dbo.hl7_allePatientnummers.

UNION implies GROUP BY for all selected values.

GROUP BY changes all further WHERE checks to HAVING ones. What makes it impossible to use indexes for...

Chris Harshman (9/29/2008)

---

If your INSERT statement can add multiple rows to the table, then you can use the OUTPUT clause of the INSERT statement to put the entire list into...

Jeff Moden (9/20/2008)

---

For performance, I prefer the SELECT/INTO. For clarity, either one will do. But, like anything else, it all depends... what if I don't need all of...

The way you database is built is a dead end.

An attempt to copy objects to tables is typical error of developers-beginners.

It will lead to overcomplicated and very pad performing code....

Usual...

There is no really point to turn back to full mode.

Log file sequence is already broken, no much use of it.

Add disk space.

And normalize data in order to decrease row size in long table.

If row size would not exceed 40 bytes deleted amount of data would be just 200M -...

Jim Russell (9/18/2008)

---

Sergie:

Interesting that with the "WITH SCHEMABINDING" clause removed, the return is 0 = Not Deterministic. I guess I don't understand why that has anything to do with...

Make views from most used joins.

Then reuse those views in further queries/views.

But be careful: no aggregations, no TOP 100 PERCENT, no data modifications in such views!

Otherwise you kill system performance.

SELECT DATEDIFF(wk, 0, GETDATE())

gives you number of full weeks from "zero date"

Adding this number of weeks to "zero date":

SELECT DATEADD(wk, DATEDIFF(wk, 0, GETDATE()), 0)

gives you beginning of curent week.

To get...

No, you need proper database.

Proper schema, proper data normalisation, proper data types, proper keys, proper indexes, etc.

You...

Well, I see what you've done, and I'm gonna try it.

I cannot say I really love the idea with "thorn" character because there is no guarantee some other developer on...

You always welcome.

If needed no problem to post it 3rd and 4th time.

I just wanted OP to ask. 😉

It's really syntax error, as it says.

Open "Create Table" template in QA and see the correct syntax.