http://jmkehayias.blogspot.com/
Name: http://jmkehayias.blogspot.com/
Score: 9
Last Seen: 357 days, 16 hours, 57 minutes ago
Member Since: 8 August, 2009
SqlServerKudos
atom rss
2
kudos
spam Kudos Remove

RANT: Got Performance Problems? Buy bigger hardware!

published 355 days, 5 hours, 25 minutes ago posted by sasa 361 days, 4 hours, 13 minutes ago
Monday, August 10, 2009 2:33:32 PM GMT Tuesday, August 04, 2009 3:45:26 PM GMT
Ok, so the title of this thread is very tongue in cheek, or in layman's terms a bunch of crap.  However, it is the most common answer I seem to get from application vendors these days when dealing with performance issues, despite the fact that I can point out a dozen reasons why their application design/code is the problem.  As I tell my end users all the time, I am sure that bigger hardware will hide the problem, but shouldn't we expect an application vendor to fix their junk design/code rather than thr... (more)
category: Management | clicked: 0 | comment | | source: sqlblog.com
tags: Performance
3
kudos
spam Kudos Remove

The effects UNION in a SQL query « WebbTech Solutions

published 352 days, 3 hours, 45 minutes ago posted by joewebbjoewebb 359 days, 6 hours, 6 minutes ago
Thursday, August 13, 2009 4:13:26 PM GMT Thursday, August 06, 2009 1:52:30 PM GMT
In a recent blog, I shared some of the natural but sometimes unanticipated consequences of adding DISTINCT to a SELECT statement. Adding DISTINCT ensures that you don’t have duplicated rows in your result set, but that assurance comes at a price. Performance is typically impacted negatively when you add DISTINCT to a query. You can read the blog and see the proof here. But there is another operator that can have some not-so-obvious side affects. Let’s a have look how UNION can affect a query’s performan... (more)
category: Query | clicked: 4 | comment | | source: webbtechsolutions.com