Last week I presented at the March Minnesota SQL Server User Group (PASSMN) meeting on using CTEs in SQL Server. The session is meant as an overview and introduction to CTEs with some examples of their use and what some of the effects can be.
Overall the session was well received and I got the following scores:
|Effectiveness of Demos||4.211|
|Usefulness of Materials||4.289|
|Blend of Demos||4.447|
I had some pretty good comments from the attendees:
- Demos can be better organized
- Good job
- Great display of CTE uses
- Great stuff – I can’t wait to start putting them to use
- I found it to be a very interesting demonstration. My work still uses SQL 2000, but they’re looking to conver to 2008 later this year, so good.
- Very informative
And some that a little less than happy but still very useful for the next time I do this presentation:
- Seemed like too much time was spent on the surface repeating examples when we could have gone further in depth.
- Add some useful examples for takeaway
- Too much focus on simple example and not enough focus on complex useful examples
- Lots to cover, a bit rushed due to time constraints
For those that want to dig into some of the examples provided, here is the presentation for download.