Hi Julia,

I have successfully used this profiler tool. At first even I got the error message as soon as i clicked test connection. But it worked perfectly when I added...

I think I got it cleared by u'r answers.

regards

shown

That was fine.

But could U tell what U would look for If such performance

problems happens with U.

regards

shown

Even I don't have much knowledge about the query.

But they where asking in a general way, which means

What would we do generally to such a query which perform well

to certain...

Mr Ray,

The Question was asked to me for an Interview,they didn't

say much details about the query.

For u'r knowledge it was actually run from an application

and the queries where...

Nice way to finish.

Anyway thank U very much for the help and to everyone involved.

regards

shown

Ok, Does it mean that it's better to prefer

SET BASED APPROACH above all other methods.

...

Please give me some examples regarding

"What did u mean by this SET BASED APPROACH"

regards

shown

Mr Jesper,

I think this is the technique what U have meant.

****************************************************

eg:-

SELECT @id=MIN(id) FROM TABLE1

SET @minid=@id

WHILE @minid IS NOT NULL

BEGIN

...

I am honoured to be a part of this discussion on the

performance of table variables and temporary tables.

Thank U very much for the feedback,as i have cleared a

doubt...

Mr Dave,

The main reason I used this performance checking was because I

actually so an article in SQLSERVERCENTRAL

"The ARRAY In SQL Server 2000" by Mr.Alex Grinberg

saying Table variables are...

That means we can use it with real execution plan but not

with Estimated Plan.

Is it being set like that for some hidden reason.Or is it a bug

in SQL SERVER.

regards

...

Mr Remi,

I didn't get u'r last sentence.

Please will U make it more clear.

regards

shown

Dear Remi,

Even I had the same answer as U told.

But the interviewer made me think in a way one of them is faster than the other.

regards

...

Dear Remi,

I don't have a specific scenario.

This Question was asked to me for an interview.

If possible will U be able to say some scenarios where Functions are faster than procedures...