Lots of things can prevent parallel execution plans, but inline UDFs are not one of them. Inline UDFs are essentially macros - they are at least as fast as CTEs. As such, the optimizer can produce exactly the same parallel execution plans whether if our queries are wrapped in inline UDFs or copied and pasted into the main query. As usual, I will ...

This week, SQL Sentry has launched a new performance-related SQL Server blog: SQLPerformance.com. I'm very excited about this new project, and I'm looking forward to some good information flow in both directions. The goal is to present new and interesting solutions to some common problems, and to explore both old and new SQL Server features from ...