SQL Server 2005 T-SQL

Question

SQL Server 2005 T-SQL

dastagirid

SSCommitted

Points: 1810
More actions
October 16, 2008 at 5:12 am

#194586

Hello,
Explain about the attachment.How to increase my query performance.
Regards:
Dastagiri.D
Thanks
Dastagiri.D

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Since you're reading all rows and all columns from the table (select * with no where clause), there is no way to get that particular query faster. It has to read the entire table.

If you're interested in learning about exec plans, have a look through these blog posts

http://sqlinthewild.co.za/index.php/category/sql-server/execution-plans/

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

dastagirid SSCommitted Points: 1810 More actions · Answer 2

hi Gail Shaw,

Thank you,

Dastagiri.D

Thanks
Dastagiri.D

dastagirid SSCommitted Points: 1810 More actions · Answer 3

Hello,

How to use SQL PROFILER IN SQL SERVER 2005.

SEND ME ANY GOOD LINKS FOR ME.

THANKS

Dastagiri.D

Thanks
Dastagiri.D

David Benoit SSC-Dedicated Points: 34562 More actions · Answer 4

Jack Corbett, a frequent poster on this site, has a bunch of "how to" videos here - http://www.jumpstarttv.com/Search.aspx?terms=profiler

This should give you some great information to get started.

Enjoy!

David

@SQLTentmaker

“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

dastagirid SSCommitted Points: 1810 More actions · Answer 5

Hi

Jack Corbett,

This videos is very use full for me.

Thanks.

Dastagiri.D

Thanks
Dastagiri.D