SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Craig Outcalt / Who was that Affinity Masked Man? / Latest Posts

RE: Who was that Affinity Masked Man?

SQLBOT — Tue, 28 Oct 2008 07:16:48 GMT

[quote][b]scott vandenelzen (10/24/2008)[/b][hr]the code posted we incomplete. can we get the entire thing :)[/quote]IT's all there. Did you see the scroll bar in the code section?

RE: Who was that Affinity Masked Man?

SQLBOT — Tue, 28 Oct 2008 07:15:12 GMT

That's pretty tight, thanks Ryan.I don't use tally but I might investigate it. Something about adding a table to avoid loops smells a tad like hackery to this robot :)Great catch on the int overflow. I'll try to update the article.

RE: Who was that Affinity Masked Man?

Ryan C. Price — Mon, 27 Oct 2008 23:35:17 GMT

Ok, so I'm a (posting) noob on this site, but aren't loops discouraged in these forums?If you have a zero-based Tally table, you can replace your initializer and loop with something like:[code]INSERT INTO @PROCMASKSTABLE SELECT CAST(c.value AS INT) & Bits.BitMask AS Mask FROM sys.configurations AS c CROSS JOIN (SELECT Number AS BitNo, CAST(POWER(2.0, Number) AS BIGINT) AS BitMask FROM Tally WHERE (Number <= @NUMPROCS and Number <= 31)) AS Bits WHERE (c.name = 'affinity mask')[/code]not saying it's any faster, but the anti-loop people will like it much better :)Also, I think your code will fail on processor 32 (bit 31), because you'll get an integer overflow - try this and see what I mean:[code]select 1073741824 * 2 -- 1073741824 == 2^30[/code]you need to use a BIGINT.Also, although I also can't test it, because I don't have more than 32 processors, I think the Affinity64 mask is also a 32-bit number,for processors 32 through 63, and that you need to use the same logic as for the first 32, and add 32 to resulting numbers.../Ryan

RE: Who was that Affinity Masked Man?

scott vandenelzen — Fri, 24 Oct 2008 07:10:32 GMT

the code posted we incomplete. can we get the entire thing :)

RE: Who was that Affinity Masked Man?

Andrew Peterson-472853 — Sat, 18 Oct 2008 08:25:33 GMT

Nice job

RE: Who was that Affinity Masked Man?

Anipaul — Fri, 17 Oct 2008 00:55:01 GMT

Cool Cool article. :)

Who was that Affinity Masked Man?

SQLBOT — Fri, 17 Oct 2008 00:30:03 GMT

Comments posted to this topic are about the item [B]Who was that Affinity Masked Man?[/B]