Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««56789»»»

How to Increase Query Speed by 3 Orders of Magnitude with no Indexes Expand / Collapse
Author
Message
Posted Wednesday, July 14, 2010 1:37 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 3:52 PM
Points: 33,268, Visits: 15,440
I've altered the title. I can see how it upset some people expecting it to contain some SQL magic.

This happens all the time. Anyone that says this doesn't happen in 2010, or that it's obvious you communicate with the business, or agile solves this, is full of crap. Good people with good communication skills and willing to try and work with others solve these issues. Too often in all phases of business, not just technology, we don't have those people.

I debated about how to phrase it and run it, and in the end like what Stephen had done. It's a well written reminder that there's more to our jobs than code.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #952668
Posted Wednesday, July 14, 2010 1:56 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 14, 2014 3:52 PM
Points: 12, Visits: 126
Ditto!
Post #952680
Posted Wednesday, July 14, 2010 2:10 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, July 16, 2012 10:19 AM
Points: 46, Visits: 177
This is a mistake sorry
Post #952689
Posted Wednesday, July 14, 2010 2:15 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, July 16, 2012 10:19 AM
Points: 46, Visits: 177
gary.strange-1058508 (7/14/2010)
I can't believe this even made it into sqlservercentral. If this dribble is the quality of articles to come I think I will look for a better provider.

If you can't interact with the whole business entity then you are in the wrong vocation and you should think about a change of career.


I think that replies should avoid attacking the author of an article. That is not productive at all. The author took the initiative to share an experience. If you believe the author to be in error, reply with respect and include the logic behind your opinion. If you don't feel this way about it, please refrain from replying.
Post #952692
Posted Wednesday, July 14, 2010 2:54 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, January 27, 2014 10:14 AM
Points: 1,322, Visits: 1,091
It implies there is some meaningful, presumably technical information within.

I think you got the point while missing the point. Not all solutions to technical problems are technical. Stepping back and asking "What do we really need?" is an important and oft overlooked strategy to solving a problem.
--
JimFive
Post #952719
Posted Wednesday, July 14, 2010 5:24 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 24, 2010 11:23 AM
Points: 1, Visits: 3
An excellent article with emphasis on how to involve users in the design process. About 40 years ago I was working with a main frame system person as a representative of the business users of the company. He asked me what I wanted and how would I like it to look (in those days, users did not touch consoles).

He was the first computer person that ever asked me what I wanted. I never forgot him and as a developer for the last 33 years, I ask the same question of my users. I also want to learn how they work so that my system does not force them to alter their work flow.

The programming is just a tool to give the users what they want. Thanks for reminding us.
Post #952786
Posted Wednesday, July 14, 2010 6:32 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 9:32 PM
Points: 21,755, Visits: 15,459
Stephen Hirsch (7/14/2010)
...je ne regrette rien...



Ah bon. Vous parlez francais aussi?




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #952800
Posted Wednesday, July 14, 2010 9:22 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 8, 2010 4:26 PM
Points: 1, Visits: 15
What if there are some updates to the historical data?
Post #952828
Posted Wednesday, July 14, 2010 11:46 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 4:53 AM
Points: 229, Visits: 166
Dear Stephen,
How does this improve the query speed when the previous 3 hour sql and current 15 seconds sql actually querying diffrent tables and views?

Wondering why your team waited till UAT to find this very visible issue .


--------------------------------
Post #952857
Posted Thursday, July 15, 2010 1:23 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 2:22 AM
Points: 43, Visits: 468
This is a forum, inviting users to express their opinion.

I would consider using cut & paste to repeat your comment along the thread contributes nothing of substance.

Perhaps my comments about the article was a little harsh, but I like many others were tricked into reading this article which meant that other articles submitted by other authors were robbed of some exposure to the readers (reducing their AIR).

In my experience developers have plenty of opportunity to interact with the whole business but they choose not to. They're not interested in contributing and assume that just coding page after page of shocking code makes them a developer.

In my humble opinion the title should be "get your head out of the sand and interact with your business and you'll find you can achieve so much more!".
Post #952893
« Prev Topic | Next Topic »

Add to briefcase «««56789»»»

Permissions Expand / Collapse