I’m no beginner to using SQL databases, and in particular SQL Server. However, I’ve been primarily a SQL 2000 guy and I’ve always been confused by schemas in 2005+. Yes, I know the basic definition of a schema, but what are they really used for in a typical SQL Server deployment? I’ve always just used … Read more
Interfaces allow you to create code which defines the methods of classes that implement it. You cannot however add any code to those methods. Abstract classes allow you to do the same thing, along with adding code to the method. Now if you can achieve the same goal with abstract classes, why do we even … Read more
Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the question so it’s on-topic for Stack Overflow. Closed 9 years ago. The community reviewed whether to reopen this question 5 months ago and left it closed: Original close reason(s) were not resolved Improve this question The question … Read more
What does the term referential transparency mean? I’ve heard it described as “it means you can replace equals with equals” but this seems like an inadequate explanation. 14 Answers 14
This question already has answers here: What is a plain English explanation of “Big O” notation? (43 answers) Closed 4 years ago. I’m asking more about what this means to my code. I understand the concepts mathematically, I just have a hard time wrapping my head around what they mean conceptually. For example, if one … Read more
Are there any O(1/n) algorithms? Or anything else which is less than O(1)? 32 Answers 32 This question isn’t as silly as it might seem to some. At least theoretically, something such as O(1/n) is completely sensible when we take the mathematical definition of the Big O notation: Now you can easily substitute g(x) for … Read more
Locked. This question and its answers are locked because the question is off-topic but has historical significance. It is not currently accepting new answers or interactions. So I’m using an app that stores images heavily in the DB. What’s your outlook on this? I’m more of a type to store the location in the filesystem, … Read more
I’ve used recursion quite a lot on my many years of programming to solve simple problems, but I’m fully aware that sometimes you need iteration due to memory/speed problems. So, sometime in the very far past I went to try and find if there existed any “pattern” or text-book way of transforming a common recursion … Read more
Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this question? Update the question so it focuses on one problem only by editing this post. Closed 3 years ago. Improve this question A Y-combinator is a computer science concept from the “functional” side of things. Most programmers … Read more
What is an NP-complete problem? Why is it such an important topic in computer science? 14 s 14 What is NP? NP is the set of all decision problems (questions with a yes-or-no answer) for which the ‘yes’-answers can be verified in polynomial time (O(nk) where n is the problem size, and k is a … Read more
