Monthly Archives: May 2014

When should I use a stored proc and when should I use a view?

I taught an Introduction to T-SQL class this week in Colorado. It was such a great week teaching and was probably the best group of students I have ever taught. There were lots of questions, and I realized that several would … Continue reading

Posted in T-SQL | Leave a comment

Kids and Coding

Tomorrow morning I am headed to Denver to speak the first meeting of the first PASS physical WIT chapter. As a representative of the PASS Virtual WIT chapter, I answered questions, asked questions, and generally was a resource available for … Continue reading

Posted in Life in IT | Leave a comment

Using Distinct with Window Aggregates

This past Saturday I presented my T-SQL Window Function Performance session at the Atlanta SQL Saturday. There were some interesting questions from the audience that didn’t actually pertain to performance. I didn’t have all the answers since there were some questions … Continue reading

Posted in T-SQL Window Functions | Leave a comment