10xer means that I produced 10x as much usable code (as measured by the number of objects checked into source control) as the average person in my group (not including me) We also had a ticketing system in which I closed 2.5x as many tickets as the next best person. Note that this was before I got into management. But even with my management duties I was still the top ticket closer and object contributor, just not as far ahead of the next best person.
@JoeObbish Don't be bothered by the literal wording of the close reasons. The community applies the rules. If it's good and useful, I expect it will be up voted and left open.
The rules exist to prevent/remove stuff we don't want or which is harmful to the community. If it's judged on topic and useful it stays.
I think we do quite well at only closing/deleting stuff that is quite frankly crap. (which includes stuff that would be good elsewhere, but doesn't fit Q & A style).
The other thing I'd say is that asking a question is good, even if you intend to self answer, because someone else may have a better answer you hadn't considered.
If you compute the record using the simple size addition you indeed get 8: 4+1+2+1 (header+fixed size+null bitmap count+ null bitmap itself). But a heap record cannot be smaller than the forwarding stub size, which is 9 bytes, since the record must guarantee that it can be replaced with a forward...
> But a heap record cannot be smaller than the forwarding stub size, which is 9 bytes, since the record must guarantee that it can be replaced with a forwarding stub.
This answer only covers SQL Server. The answer depends on how you define efficient: is it space or CPU? There can be a tradeoff between the two.
Let's start by checking the documentation for data types that store integer data:
╔═══════════╦═══════════════════════════════════════════════════════...
I have a question (Cross join on a numbers table to get line vertices, is there a better way?) where I received a very thorough/detailed answer. The answer wasn't so much an answer as it was a series of questions.
I found the answer to be immensely helpful, and thought it was only fair to post m...
@PaulWhite I've added 'binary', 'image' and 'timestamp' to the list of types to convert to hex (which works fine), but the hierarchyid,geometry and geography types have me stumped. Rather than just failing, it now returns the typename which is still pretty useless
I seem to be having a huge performance gap between using hard coded values for a SELECT IN, vs a STRING_SPLIT. The query plans are identical except for the last phase where the index seek is getting executed multiple times for the STRING_SPLIT code. The outcome is a CPU time of about 90000 vs a...
This answer only covers SQL Server. The answer depends on how you define efficient: is it space or CPU? There can be a tradeoff between the two.
Let's start by checking the documentation for data types that store integer data:
╔═══════════╦═══════════════════════════════════════════════════════...
I seem to be having a huge performance gap between using hard coded values for a SELECT IN, vs a STRING_SPLIT. The query plans are identical except for the last phase where the index seek is getting executed multiple times for the STRING_SPLIT code. The outcome is a CPU time of about 90000 vs a...
