and one more thing...

suppose,if i forget my password...then do i have to uninstall SQL server ?

can i get back passwrd from SQL Server ?

i think you are asking for this

http://imgfly.com/files/270906_110055/web3.JPG

How can i solve this problem

hi,ok.

so is this all about query tuning ?

it seems easy then .

i need to check indexing on columns and have a stop-watch with me to see the time of result.

its...

oh..yes...thats from book

Microsoft SQL Server 2000 Administrator's Companion

by Marci Frohock Garcia, Jamie Reding, Edward Whalen and Steve Adrien DeLuca

Microsoft Press © 2000

Hi,

here i have found one optimization trick...

In this section, we’ll look at a query that requests information about orders that have been placed by an employee whose employee ID is...

i think you meant this book

Inside Microsoft SQL Server 2000

by Kalen Delany

ah...i can read this book online from 24x7 book online.

i see it has 2 chapters

Chapter 16...

by the way,

do you know any such book which exactly tell me the solution for this kind of problem ?

can you please tell me the name of book...

where from i will get query plan !

then i'll have to make a table with how many records ? 1 lakhs ?

well, i will write a java program.

the program will...

i dont have it .

but i am trying to learn this concept so that if i fall in this same situation i can resolve it.

I am learning.

so, an example...

i am trying to learn ...hope you guys help me.

i see they are providing statistics of cost 1 % , 16 % etc etc.

so, as a primary guess , it seems in-effectively you shall be targetting to reduce...

>Check your query plan (sql query analyzer ->display estimated >execution plan)

you told query plan

like this ?

http://en.wikipedia.org/wiki/Image:SQLServer_QueryPlan.png

but what can i do with this ? how it help to...

if you know , can you kindly please tell me OR forward me the relevant links how to do it .

do i need to create an index for the column...

Nothing understood.

can you please tell me the steps for MS SQL server 2000

yes, sreejith

query takes longer time.

how do i speed up ?