then...after janine.rawnsley's post what is the final word for this topic to use join or "or" operator!

or it depends from the relations between tables..plz advice!

???

:hehe:

great topic with useful things here ... thnx friends for everything that you reply here!

:hehe::hehe::hehe::hehe:

nice and useful topic...thnx!:P

o nooo I didn't know that the backup strategy changes from SQL server 2000 in SQL Server 2005 ...o nooo at least this detail o nooo!

:D:D:D:D:D:D:D:D:D

Me too, I lose but I learn professional way thnx!

😛

This is nice article & useful... not bad!

Great post here!

Thnx! 😉

it works!...thnx!

:hehe:

So what about if you want to create a link to Access database!?

the link is working but when it creates, you can see what happened with hierarchy:

please see the attachment!

so...

There is the results:

retrieving from the table with the same where clause it takes 1:33 (min:sec)

from view with 4 columns it takes 0:33 ( min:sec)

so the table definition is with...

It depends from the users rights!

the more efficient is view sometimes when you have to use the particular data for some users, because you eliminate many unnecessary columns to view...

thnx for Reply!

🙂

ok there is the results for my table with over 1 500 000 records:

updateing

25 000 rec for 1:22 (min:sec)

250 000 rec for 7:19

over 500 000 or exactly 676 561...

I confused with this problem so I forget that...

Hmmm ...it's impossible ok the syntax of the procedure works and has been created but when I execute them both of them again doesn't work there is msg:

Msg 201, Level...

ookkk now works fine ...thnx from all of you !!!