Query Performance

Question

Query Performance

-Syd-

Mr or Mrs. 500

Points: 543
More actions
November 7, 2011 at 5:57 am

#246334

Hello everybody, more than a specific consult is a general wonder.
I need to a improve a query performance but, before that, can you please give a few tips for general performance, or if there already a section on this forum, post the link please.
Thank you very much!

Viewing 15 posts - 1 through 15 (of 16 total)

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

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

There are entire books written on that. Literally

http://www.amazon.com/Server-Query-Performance-Tuning-Distilled/dp/1430219025/ref=sr_1_1?ie=UTF8&s=books&qid=1237206053&sr=8-1

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

-Syd- Mr or Mrs. 500 Points: 543 More actions · Answer 2

Yes, I was aware of that, but I'm from Argentina and our "dear president" (sarcasm) do not allow us to buy dollars or made transaction in dollars, so I cant buy anything from Amazon or Ebay.

I know it really s....ks.

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

Then free is the way to go => http://www.sqlservercentral.com/articles/books/65831/

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

Ninja's_RGR'us (11/7/2011)
Then free is the way to go => http://www.sqlservercentral.com/articles/books/65831/

Not the same book.

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

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

-Syd- (11/7/2011)
Yes, I was aware of that, but I'm from Argentina and our "dear president" (sarcasm) do not allow us to buy dollars or made transaction in dollars, so I cant buy anything from Amazon or Ebay.

You must have local book shops that you can order the book through.

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

-Syd- Mr or Mrs. 500 Points: 543 More actions · Answer 6

Yes we have of course, but the prices are extremely high.

For example: 1 us dollar(u$s) = 4,30 Argentine Pesos ($)

If a book on Amazon cost u$s40, you assume here is around $172, plus some additional import tax, $200 pesos is a reasonable price, but no... that book is not below $400 at least, so you are paying double from the real price.

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 7

-Syd- (11/7/2011)
Yes we have of course, but the prices are extremely high.
For example: 1 us dollar(u$s) = 4,30 Argentine Pesos ($)
If a book on Amazon cost u$s40, you assume here is around $172, plus some additional import tax, $200 pesos is a reasonable price, but no... that book is not below $400 at least, so you are paying double from the real price.

Same problem from Canada. Shipping ain't cheap!

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

-Syd- (11/7/2011)
Yes we have of course, but the prices are extremely high.
For example: 1 us dollar(u$s) = 4,30 Argentine Pesos ($)
If a book on Amazon cost u$s40, you assume here is around $172, plus some additional import tax, $200 pesos is a reasonable price, but no... that book is not below $400 at least, so you are paying double from the real price.

Only? That's cheap.

If I buy a book from Amazon I can get it (without shipping) for around R300-R400. Buy it in the book shops here, I'm unlikely to get it for under R800-R1000.

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

-Syd- Mr or Mrs. 500 Points: 543 More actions · Answer 9

Here if you buy a book on amazon plus the shipping charge you save between 25% or 35% than the price that is here on Argentina.

But were losing focus on the topic I think, sorry about that.

I'm looking at the free book, is not really what I'm looking for right now, but is pretty useful, thank you very much!

If someone has a free book or tutorial on improve query performance, please let me know.

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 10

Combine that book to those articles and there's not much more you need to know (to start with).

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2

-Syd- Mr or Mrs. 500 Points: 543 More actions · Answer 11

Thank you very much!

I'm working on this query for almost a week!!!!

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

My articles aren't going to tell you how to tune a query. They're a high-level coverage of how to find the problems and a bit on indexing.

There's lots and lots online, but it's in bits and pieces and the quality varies from excellent to downright harmful.

p.s. Have you considered posting the query here?

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

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 13

Then post the actual execution plan. A fresh pair of eyes might really help out.

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 14

GilaMonster (11/7/2011)
My articles aren't going to tell you how to tune a query. They're a high-level coverage of how to find the problems and a bit on indexing.
There's lots and lots online, but it's in bits and pieces and the quality varies from excellent to downright harmful.

That's why I posted to Grant's book. All excellent and a great starter.