WayneS (1/19/2016)

---

Eirikur Eiriksson (1/19/2016)

---

Suddenly everythings is so quiet, no notifications or emails blimping on the phone, not a single message since early afternoon, am I lucky or maybe Steve, is...

GilaMonster (1/19/2016)

---

*sigh* All but one comment on a blog post are of the form 'Did you try X?' 'Have you compared Y?' 'Probably should have a test with Z'

*NO. If...

Jacob Wilkins (1/19/2016)

---

Throwing in the CASE using Eirikur's wonderful setup yielded this on one million rows on my machine (tangentially, I'm embarrassed that Eirikur's laptop is faster than my test...

Suddenly everythings is so quiet, no notifications or emails blimping on the phone, not a single message since early afternoon, am I lucky or maybe Steve, is SSC's email service...

Looks just like the waiter (as I remember him/her) when we left the pub the other day:-P

😎

Jason A. Long (1/19/2016)

---

Eirikur Eiriksson (1/18/2016)

---

Nice idea but I see two potential problems, firstly the costly concatenation and substringing with the data type conversion is going to impact the performance...

My apologies for not substantiating my previous posts earlier, slightly busy:-P Just had few minutes to piece together a quick test harness, please feel free to improve and add to...

Nice write-up Ed, good job!

😎

Just to mention, xp_fixeddrives is very handy for doing a quick check.

Jason A. Long (1/18/2016)

---

Just for the fun of it... Here's a solution that uses a cast to binary & contaminate method...

Test data...

IF OBJECT_ID('tempdb..#temp', 'U') IS NOT NULL

DROP TABLE #temp;

CREATE...

Orlando Colamatteo (1/18/2016)

---

@mister.magoo, never seen APPLY used with a row-ctor to unpivot like that. Very cool.

Just for the sake of providing an alternative, we can do the same using a...

Jeff Moden (1/18/2016)

---

Ah... got it. Because of your references to Little Endian, I thought you were talking about converting 255.255.255.255 to 255255255255 as an Integer, which requires 5 bytes...

Jeff Moden (1/18/2016)

---

Eirikur Eiriksson (1/18/2016)

---

Network endian-ness is predominantly big-endian and the method NetworkToHostOrder will swap the byte order to small-endian. This tells me that you are storing the IPs as...

thierry.vandurme (1/18/2016)

---

Sure, at the risk of getting shot because of bad coding 😉

We have two helper functions converting from/to long/ip.

We subscribe to the datagrid's CellFormatting event and change the...

You are very welcome.

😎

Must be getting tired, just realized that the XML shredding was heavily affecting the timing, adding a table for the ip ranges brings the matching of the 5 million down...