Here’s a quick summary of OVER and PARTITION BY (new in SQL 2005), for the uninitiated or forgetful.
Dear Users, We, the tech people, understand that you just want technology to work so you can get your jobs done. We really, really understand that. When your technology doesn’t work, you turn to us so we’ll make it behave. We like making technology behave – we got into this field on purpose. But when […]
Sean’s latest rant – about a vendor with a dangerously small amount of SQL knowledge – has spurred me to talk about a common theme I’ve been seeing lately: Proving facts to ignoramuses*. How to Prove Facts to the Unbeliever State the fact. Explain the fact. Restate the fact. [Realize here that they won’t listen […]