Gail,

If you will become the DB designer then which model do you prefer??

I mean to say...a Covering Index on the table OR a Index on Foreign Key column??

Gail, As you...

Michael,

You mean to say if foreign key will have the Index then it will go for Index scan rather than table scan in the time of delete operation...rite??

so here my...

Yes,

I will check this...Thanks...:)

Cheers!

Sandy.

🙂 Ok, Nice to see all of your answers,

but as for my concerns and my question,

If you say "It depends" then please let me know the situation where I should...

Grant,

nice to here that you too curious to know more about this technology.

If anybody knows "POWERSHELL" concepts please share your experiences...

Cheers!

Sandy.

hey Eichpeel & Jeff Moden ,

I am sure it will work, because I applied the same and got the success..

one of query took 27 seconds to execute..but when it...

toprprasad

-------------------------------------------------------------------------------------------------------------------------------------------------------------

Now the question is,

is it advisable to have separate master table for sports/games and display these sports on reg form

or

Shall i have separate column in reg table...

Yes, It will be present in database like table when you query it, it will display to you. Its a permanent object of Database.

read this...

http://www.odetocode.com/articles/299.aspx

Cheers!

Sandy.

😉

Yeah,

I was also same kind of problem having problem some days before...

then I used updatestats and few above displayed method (with recompile, drop and re-created the procedure) then it...

Simon,

Nothing like that..you are the 1st is saying like this..

try to reinstall your IE again and check this it will not happen...

try it...

And One personal question...?????

why you added one Tom...

Simon Facer

------------------------------------------------------------------------------------------------------------------------------------------------------------------

This loop is never going to quit - the value for @TotalBilled never changes inside the WHILE loop, so it can never become NULL and end the loop. Still,...

Milu,:)

Yes, Obviously...

I can guide you the XML and Array comparison ...

In your general Programming language the Array is just group of data following subscript number starts from 0, which gives...

mtassin, Can you tell me...

Yes, thats true...:)

Cheers!

Sandy.