It continually amazes me how often in the SQL Server world that a complete newbie gets thrown into the deep end of the pool and made responsible for mission-critical stuff....

Rowan (8/19/2009)

---

Thanks, I will visit this option, but because I'm drawing data from a DB2 database I will have to see how this can be done.

Just to give you an...

Jeffrey Williams (8/19/2009)

---

SQL Server will only release memory back to the OS when the OS needs that memory. On dedicated SQL Server machines - that will never occur. ...

I have used ERStudio for the better part of a decade. IIRC you can get (or used to could anyway) sql server specific licensing that is MUCH cheaper than...

joeroshan (8/19/2009)

---

Thanks Grant. I got the point. I was asked how to place files for a new project and I actually did suggest that the safest bet was three different...

hey, what about using 32 bit fields??

just kidding

😀

Hey Jeff - I gotta ask: do you actually WORK for a living?? Maybe you get paid for what you know and not what you do at work?...

You are correct Jeff - it was a very good article. Much better IMHO than much of what is put out on the web these days.

As for your constructs,...

Thanks for taking the time JS. Looks like a lot of the timing is in returning the results to the front-end (RTRIM much faster). But looks like overall...

assuming completely random distribution of IP numbers for all octets (no idea if this is valid or not) then the average length of an octet is 2.57 if my math...

Jean-Sebastien Carle (8/19/2009)

---

TheSQLGuru (8/19/2009)

---

The point would be exactly what your article was about - what offers the best performance. There is a chance that fixed storage will perform better...

Jean-Sebastien Carle (8/19/2009)

---

I'm not sure what would be the point since IP addresses (when used as...

could you please redo your testing using a char(17) datatype instead of a varchar(17)?

1) failure to do disk partition alignment can rob an IO subsystem of double-digit percentage throughput capability. In the worst case (pure 64K random IO) you can gain 100%...

I am not saying that it won't work, nor that there aren't valid reasons for having multiple instances. But consolidation for consolidation's sake is not one of them. ...