(Tim Ford) I didn’t intend to write this article. Let me rephrase that: I did not set out to write about this subject when I sat down in front of my computer this morning. I ended up doing so as I was working on an article about poor uses for the DISTINCT keyword when I had an unexpected discovery i
Other News
Myths and Reality of Iterative Testing
Video Programming for IT Professionals Career management advice, coaching and much more. We discuss making the best of your professional development, provide specific tips and ideas for advancing your career and even answer questions from field.
#0348 – SQL Server – Msg 1946 – The index entry exceeds maximum length of 900 bytes
(Nakul Vachhrajani) Having indexes on character columns is fairly common in OLTP systems that deal with multiple look-up values. However, indexes on character columns come with a small catch.
Watch Out for Misleading Behaviour From SQL Server
(Michael J. Swart) I often have conversations where a colleague wants to understand why SQL Server performs faster in some cases and slower in other cases.
Why don’t they make the optimizer faster? (An essay on nested views)
(Jen McCown) We got a question recently that basically boiled down to this: Nested views shouldn’t be such a performance suck. Why doesn’t Microsoft make the optimizer deal with nested views better?
Webinar: Why IBM DB2 Database Software Leaves the Competition in the Dust
We all know that IBM DB2 database software is an industry leader when it comes to performance, scale, and reliability. But how does it compare to the competition, specifically Oracle and SAPHANA?
Four Ways to Drive Analytics into your Data Management
(Dave Beulke) Data from personal health monitors, airplane/car mechanical sensors, location movement instrumentation, image processes, and voice prints audio analysis are exploding databases in all aspects of business.
JavaScript unit testing: guiding principles and common excuses
(Matt Harrington) There’s a lot of interest in JavaScript at Microsoft. Did you know that:
Using OUD Transformations to expose Operational attributes as Regular ones
(Sylvain Duloutre) Some (badly written) LDAP client applications expect to get operational attributes along with regular attributes when they search the directory w/o specifying attributes explicitely. The LDAP standards specify that operation attributes have to be explicitely requested in the searc
Splitting Tables in Entity Framework 6 to Improve Performance
(Peter Vogel) There are some occasions when using Entity Framework can really hurt you: When you have tables with hundreds of columns or tables with large payloads. Here’s how to get EF6 to do the right thing.