Justin
  • Member for 10 years
  • Last seen more than a month ago
Interpreting SQL Server's Showplan XML
Accepted answer
9 votes

First let me just say - fantastic looking site :) This sort of thing is exactly what I wrote that XSLT for - I'm glad that others are finding it useful! I have to confes its something that I wrote a ...

View answer
Professor told us to store serialized Java objects as blobs instead of defining relational tables
7 votes

I have done this before - its a useful technique in certain scenarios however depends on the serialization format used. If I do this I make sure that I use a serialization format that allows me to de-...

View answer
Which design to choose
Accepted answer
2 votes

Both solutions are viable and each has different benefits / drawbacks - the best solution depends on your data and how many of your queries need this additional column. Adding the special_class_id to ...

View answer
Identity/Primary Key columns pattern for performance in SQL?
1 votes

On tables with a large number of rows being inserted having a ever-increasing clustered index generally improves write performance as it ensures that new records are added together "at the end" of the ...

View answer
Should I set document version field to be part of a primary key
1 votes

While there is nothing wrong with your schema, personally I would create a separate DocumentVersionId column for similar reasons to those listed in Why should I create an ID column when I can use ...

View answer
Is table aliasing a bad practice?
0 votes

You can use this to significantly increase the readability of your queries. Rather than using a short alias, use your alias to describe the data that you are joining to, for example SELECT ...

View answer