GilaMonster (11/26/2012)

What I said was

"Typically a scan is a full scan (in the absence of TOP or other operators that give row goals)"

Hence, if you see a scan and there...

Yes, in this case I can. But we have many, many, many tables and I don't know the number...

Hi Gila,

that's the point, it seems that it is NOT ALWAYS a full scan. The example shows it, using the min()-Function does...

ahaaaaaaa 🙂 now I understood

Hello Grant Fritchey,

thank's a lot for your very detailled explanation. I'm still not sure if I understand the part I'm interested in most.

I know these queries had no predicate and...

hi. here is the execution plan. some explanations:

@InsertedCumulatedDataIds:

A table filled at the beginning of the procedures. For this Ids we have to write records in table #tmpProductHistory.

The tables DetailledDataANP...

I don't think your table is normalized. Your have two entities, cars and parts. One car can have several parts, on part can be used in several cars. That's an...

hi,

for making the delete more performant you should use a loop, something like that:

delete top ( 100000 ) from myTable

while @@rowcount > 0

begin

delete top ( 100000 ) from myTable

end

For leaving...

There is no simple query for doing this update for all colums of all tables. If you only have to do it once you could use dynamic SQL.

You get the...

Why do you want to set the value "unknown" at all? The NULL already tells you that the content ist unknown. The way mentioned by John is for using in...

hello GSquared,

thank's for your answer.

Using the subselect as shown in the example or switching it to a cross apply ends up in exactly the same execution plan.

The table variables are...

hi there,

maybe this little trick helps:

I personally understood this behaviour of outer joins quite a time ago when it was explained to me as follows (yes I know, very simplified...):

there...

Thank you for your answers. I feared there would not be a possibility. Well that will be some funny days dropping these indexes 😀

scripting objects or table contents can all be done using Microsoft management studio. right click the database and choose "tasks, generate scripts". select the objects you want to script. in...

Mike Hinds (5/18/2012)

...

...

I'm interested, too. If we had a command such as "EXEC sp_help Customers", could we direct the output of that statement to a temporary (or permanent) table,...