SQLServerPedia Wiki

Less Is More, Even With Databases

Less Is More, Even With Databases

I’ve been writing (and blogging) for about ten years now. I’ve written lots of things over the years and I have learned how much better my writing becomes when I remove words upon editing. So much improvement can be found that I often feel it might have been best to have not written anything at [...]

Why the 127 Diagrams?

Why the 127 Diagrams?

Yesterday I showed you some real world SQL joins and their associated diagrams. I also left as an exercise for the reader this question regarding a standard three table join:
“explain why I could need 127 different diagrams”
I had a few people guess the answer on Twitter and G+ as well as some emails. So I [...]

Expert Query Performance Troubleshooting

This video is an hour-long but well worth sharing with you today. One of the main takeaways from this video I want you to have is the fact that troubleshooting performance is not always rocket surgery. When you watch this video and listen to Conor Cunningham talk about some of the real world examples he [...]