Conventional wisdom says to “normalize to 3rd normal form then denormalize for performance.” Poppycock! I say for an OLTP operational database (not a reporting or BI database), a well normalized design will outperform a denormalized design for three good reasons: 1)      If the denormalization duplicates data, then the ...

I am a bit new at sql server and am trying to resolve a coding issue that I have come across. I hope there is someone out there that might be able to assist me. I am working with zip code +4 data and am trying to range the data to reduce the size of the database from the current ~65 million lines of data.  The trick is that I need to range ...

When I started blogging here on sqlblog.com, I intended to write about stuff like T-SQL, performance, and such; but also about data modeling and database design. In reality, the latter has hardly happened so far – but I will try to change that in the future. Starting off with this post, in which I will pose (and attempt to answer) the rather ...

Thanks for the example and for attempting to answer my question, I've been posting it all over the place and have had minimal response, granted it's a small bit of business in Sql Server. My question might have been a bit vague, I'd hoped that by keeping it simple it might spark more conversation. So, to refine the issue using your example ...

>> Aside from this, if anyone has discovered any creative ways to resolve an xs:import against a schema stored in a different collection I'd love to hear about it. Not likely to happen. Schemas are compiled into types at cataloging so they can be statically analyzed by the query optimizer. It would be nice to say that a column is typed by ...

I'm working with typed xml in Sql server '05 and haven't been able to resolve a couple questions through the documentation or any of my searches so far - so fanfare aside here is the most immediate question: If I have an XML Schema Collection with multiple namespaces how can I specify an xml column or variable that only targets one of ...

As a DBA I have always used stored procedures to access database data for the myriad of reasons that we all are aware of. My current project has made the decision to forgo stored procedures and access data directly from the underlying tables by means of JPA. I understand the concept of persistence, but I have seen any analysis that addresses my ...

Hello guys, I have to write business solution for shortterm and new term. Scenario like this. There are two companies one is in JAPAN and other one is in UK they both making bikes. Now they merger togather, CEO is asking  the HRM department to have data of employees. Now company 1 is having won XP workstation with IBM DB2 ...

Hi - I was wondering if anybody knows of a book or white paper on the costs/benefits of different types of genericized data models (Entity-Attribute-Value or Name Value pairs, full text indexing with first abnormal form, or a more limited abstract naming convention on a limited set of user defined fields, a la Great Plains).  My company is ...