How to improve performance of the view with 12 joins

Question

How to improve performance of the view with 12 joins

Viewing 7 posts - 31 through 36 (of 36 total)

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

Andrew Gothard-467944 Hall of Fame Points: 3928 More actions · Answer 1

Paul White (11/11/2009)
CREATE VIEW dbo.CrystalBalls WITH SCHEMABINDING AS SELECT Egg FROM ( VALUES ('Egg'), ('Egg'), ('Egg'), ('Egg'), ('Egg'), ('Egg'), ('Egg'), ('Egg'), ('Egg'), ('Egg'), ('Egg'), ('Egg') ) Eggs (Egg);
...count them...there's a dozen fresh free-range ones 😛

It depends ...

If the power goes down and the system's running off the UPS, presumably they'd be battery?

(I'll get my coat)

Paul White SSC Guru Points: 150467 More actions · Answer 2

Andrew Gothard-467944 (11/11/2009)
If the power goes down and the system's running off the UPS, presumably they'd be battery?(I'll get my coat)

:hehe::laugh::hehe: ... Oh dear!

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 3

Andrew Gothard-467944 (11/10/2009)
ORM - Obscene Relation Mangling?

Heh... you must know my first wife but nope... "Overthrown Raw Meat". 😀

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

Just ran into a query here @ SSC that has 36 table joins - asking for tips to improve.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 5

CirquedeSQLeil (11/12/2009)
Just ran into a query here @ SSC that has 36 table joins - asking for tips to improve.

Can you give whomever is asking my contact information please? 😎

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service

shaycullen Right there with Babe Points: 781 More actions · Answer 6

Good point. the last step of normalisation is de-normalisation!

SwePeso SSC-Dedicated Points: 39757 More actions · Answer 7

1 week, and 4 pages of replies.

Where did OP go?

N 56°04'39.16"
E 12°55'05.25"