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 12345»»»

Falling Over our Assumptions Expand / Collapse
Author
Message
Posted Tuesday, April 7, 2009 10:08 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 5:03 AM
Points: 579, Visits: 2,520
Comments posted to this topic are about the item Falling Over our Assumptions


Best wishes,

Phil Factor
Simple Talk
Post #692730
Posted Tuesday, April 7, 2009 10:41 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, August 21, 2014 6:09 PM
Points: 522, Visits: 554
"Don't bother with that complicated outer join, just use the IN keyword"
Post #692748
Posted Tuesday, April 7, 2009 10:42 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, June 5, 2014 10:54 AM
Points: 9,902, Visits: 9,480
You know what you do when you Presume? You make a Pres out of U and Me.

No, wait. That's not right ...


-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Post #692749
Posted Wednesday, April 8, 2009 12:40 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, August 22, 2014 7:31 AM
Points: 449, Visits: 1,858
".....but we've always done it that way"


"No need for that where clause, we can filter the results in the GUI"


Regards

GermanDBA



Regards,

WilliamD
Post #692780
Posted Wednesday, April 8, 2009 1:38 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, August 21, 2014 4:21 AM
Points: 561, Visits: 1,168
"If I just join these five views together I can select the three colums I want."
which leads to
"Why does this application run so slowly?"


Never mind that they are complex, many tables, many columns selected, non-indexed views and the same tables are referenced multiple times and all it really needed was a simple select with a join on two or even three tables!
Post #692815
Posted Wednesday, April 8, 2009 2:05 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 8:53 AM
Points: 1,049, Visits: 3,003
A few really insidious ones I regularly see are

"....the user is always wrong"
"I know my sphere of expertise inside out, so I must know yours better than you as well"
"I will lose face or respect if I admit ignorance"


Semper in excretia, sumus solum profundum variat
Post #692830
Posted Wednesday, April 8, 2009 2:33 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, June 3, 2014 8:16 AM
Points: 295, Visits: 1,011
Anyone come across one stored procedure, using a couple of cursors who in turn uses a few sp's that rely on several udf's so you end up with this huge tree? Where instead some temporary tables with the correct queries would just shorten it down to a very very small tree instead? I hate cursors that is used regularly in the code when in my mind cursors should only be used for easy use for something you want to do once. I find people who write cursors are not used to sql but keep the c/c#/java/etc programming style with them into the database.
Post #692841
Posted Wednesday, April 8, 2009 2:40 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: Administrators
Last Login: Monday, July 14, 2014 2:45 AM
Points: 77, Visits: 1,305
"look it's just a place to store data..."
Post #692845
Posted Wednesday, April 8, 2009 2:43 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, August 11, 2014 9:45 AM
Points: 207, Visits: 956
Two I can think of;

"Dynamic SQL is always better than stored procedures".
and;
"Stored procedures are always better than dynamic SQL".



Oh, and a bonus one that I've seen in practice is the assumption that primary- and foreign-keys are optional.


Paul

Post #692848
Posted Wednesday, April 8, 2009 2:50 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, May 11, 2012 3:24 AM
Points: 16, Visits: 95
Not sure I agree with "'Get something up and running. We can always tidy it up later' "

You should always plan to have to tune/improve some parts of the system. When you are testing and let's say you have two testers at your disposal, there is no way you can simulate 2000 users, Deadlocks and such may only become apparent later.

Post #692852
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse