...ch this isn't the case, so you'll need to test on your target DBMS. Also, more and more DBMS allow you to provide optimizer path plans (abstract query plans) to significantly reduce optimization time (for both ad hoc and stored procedure SQL!!). WARNING Cached query plans are not a performance ...

I need to determine if a string contains two or more consecutive alpha chars. Two or more [a-zA-Z] side by side. Example: ...

...nes' and their aunts experimentation. This is serious cognitive noise. The more branches you add, the more crap you'll get to see. The more public branches you have in a repository the harder it will be to keep track of all the different branches. So the question you'll have is if the branch is sti...

...along fine for over 200 thousand years without it. ;-) 'with' is making it more secure, more readable, and one line shorter. – Romain Vincent Aug 20 '17 at 17:01 9 ...

...ro Martin : Switch statements are useful because they provide code that is more concise and more readable. Your example requires more lines than are necessary, and the code is far less clear than the equivalent if-then-else structure. It's simply a case of the right structure for the job. Just becau...

... used for every hash. In practice, this is easy to achieve by getting 8 or more bytes from cryptographic quality random number generator. From a previous answer of mine: Salt helps to thwart pre-computed dictionary attacks. Suppose an attacker has a list of likely passwords. He can hash ea...

... For trackbacks, if you dedicated 1MB to them, you could easily have more than 10k (probably closer to 20k) So except for truly bizarre situations, it'll work great. And in the exception case or spam, I really don't think you'd want a 20mb object anyway. I think capping trackbac...

... the square brackets do). Even if you're not new to it, it keeps your code more readable so that others that may have to read your code can more readily understand what you're doing. However, you can't just assign some integers separated by colons to a variable. You need to use the slice object: l...

...ame information to the query optimizer. One difference is that a CTE used more than once could be easily identified and calculated once. The results could then be stored and read multiple times. Unfortunately, SQL Server does not seem to take advantage of this basic optimization method (you might...

... in my code base once, but not regularly. (Note that this is likely to be more efficient than Andrew's LINQ-based answer - but obviously the more elements you have the more appealing the LINQ approach is.) EDIT: A "best of both worlds" approach might be to have a custom set of methods either way: ...