Thanks been trying visio but it does not graphicly display the relationships correctly(arrows are the wrong way and not connected to actual fields just the table box). I thinks...

That's what I thought as well... So except for where exact reporting is required, if you do your job right on the SQL syntax and DB design a NOLOCK...

select into will create a new table.. (or bomb if you already have that table name used)

INSERT INTO however is what you are looking for

I may be dumb here. But if you pull up the table in Mangement Studio.. Click Design.. You can then add any column in any position that...

GilaMonster (9/4/2008)

---

If you know that a set of tables are static and hence locks are an unnecessary overhead, then put those tables into a separate filegroup and mark that filegroup...

Any chance you can do your grid by hand (using the data provided) so that I can see exactly what you are hoping to see.

...

Intersting...

From what I have seen sometimes (yet rare) calling out the actual index has had a marked improvement on the execution time.

But except for your "dirty read" comment (which is...

Have some ideas... Can you provide a small data extraction from both tables to test.

Can you please provide the following....

table structure

a_mon

a_ereig

Small Data Extract from both tables....

Thank you

From the looks of it you should be getting multiple pat_nr with your query... Clean up your code a bit....

You are assigning values to @start and @end from another...

I am pretty sure that I have full permissions to this server but I get the following error from your script

Msg 297, Level 16, State 12, Line 1

The user does...

Sorry guys... no need for this one....

http://www.sqlservercentral.com/Forums/Topic159058-8-1.aspx?Highlight=row+size

Don't know why I could not find it before.....

no problem thats what this site is for.

Good catch, Gila, completly went right over that...

Couple of things that can help to speed it up....

Declare the GETDATE() as a variable and call it out... Helps with processing time.

Add "WITH (NOLOCK)" to each and every...