654 reputation
719
bio website
location
age
visits member for 4 years, 2 months
seen 2 days ago

Returning to the community and programming again.


Jan
7
asked cost trade-offs for deploying changes to prod, stored procs vs. LINQ
Jan
6
comment T-SQL stored procs orders of magnitude faster than LINQ
@qes: Trig functions not happening? How about financial functions? I definitely see those commonly in stored procs. Iteration w/ state not happening? FETCH. msdn.microsoft.com/en-us/library/ms180152.aspx String manipulation? Last time I checked LINQ to SQL, the String functions were supported. Besides that, string, regex functions that show up in the SELECT statement are easily applied after the call to IQueryProvider.Execute. programmers.stackexchange.com/a/65810/19936
Jan
6
comment T-SQL stored procs orders of magnitude faster than LINQ
@qes: Yes I do. More than 2, but not dozens, and I've written 2. Which are the dozens you've worked with? It seems that simplest table selects cannot be that different across different providers (and besides contradicting "cannot generalize"), how differently can a stored proc represent a simple select than LINQ to SQL can generate the equivalent T-SQL? The LINQ-to-T-SQL translators are already provided by the ORM framework, so where's the fight?
Jan
6
comment T-SQL stored procs orders of magnitude faster than LINQ
@qes: A good comment, but I doubt this. Cannot generalize? Is the generated T-SQL or the algorithms used to generate it from e.g. LINQ-to-SQL and Entity Framework, really so fundamentally different? By time-consuming here I assume you mean development time, not running time (i.e. the question)? Even still, not necessarily. For example, suppose your query involved concatenation, other string manipulation, iteration,with persistence of some state from one row to the next, and calls to trigonometry functions...
Jan
6
asked T-SQL stored procs orders of magnitude faster than LINQ
Dec
16
comment How to deal with people who don't want to share knowledge?
Ask yourself from their perspective, what's the benefit to them and not the team, for putting their time and effort into doing the extra work of documentation?
Dec
3
comment Why don't all companies buy developers the best hardware?
"The difference of productivity between...machines is negligible. The difference in price is significant." What is the value if you were to quantify this negligible difference? -10 min/day ? Suppose the top-end machine is $3000, and assume that almost-top-end is almost-$3000, or $2500. The difference is $500 a fixed cost distributed over 2-3 yrs. Is this your definition of significant?
Dec
3
awarded  Critic
Dec
3
comment Why don't all companies buy developers the best hardware?
Anandtech has come up with some interesting ways of quantifying performance and cost. anandtech.com/bench/CPU/2
Oct
9
accepted Prevalence of “back end” programmer roles in ASP.NET (MVC) projects?
Oct
9
asked Prevalence of “back end” programmer roles in ASP.NET (MVC) projects?
Sep
27
awarded  Nice Question
Aug
15
awarded  Popular Question
Jul
21
comment Can you get in trouble using programming forums or Q&As at work?
@perdian agreed, and another reason why : It's easier to ask forgiveness than it is to get permission.
Jul
21
comment Should Professional Development occur on company time?
@Joonas +1 again, great quote, but then isn't that the reason why it actually might hurt to ask?
Jul
18
comment How do I apply a computer science degree to web development?
I like this answer, although I don't necessarily agree with the using "pompous" to describe CS grads in general. Overconfident, maybe, but wanting to tackle CS problems shouldn't be reason to be called pompous.
Jul
17
comment How do I apply a computer science degree to web development?
I guess things are different on the LAMP side - I've done most of my work in ASP.NET (web forms), and while we do data-centric work such as CRUD operations and web services & serialization, in most work I can merely re-use a lot of CS concepts in a manner which requires little understanding of them, i.e. I don't have to think about the sort algorithms or data structures used in nearly all the LINQ queries I work with.
Jul
17
revised How do I apply a computer science degree to web development?
edited tags
Jul
17
accepted How do I apply a computer science degree to web development?
Jul
17
comment How to market yourself as a software developer?
+1 and don't forget to add these under the "Skillz" section on your resume.