View with a where clause

I was teaching a class and during an interesting discussing an attendee told me that views with a filter took a long time to produce results, even if the result set itself was quite small. I wanted to test this out for myself to see what was happening. I'll take you along this short journey … Continue reading View with a where clause

Select * in a view

My take on the inner workings of SQL Server and views

Unexpected view behaviour

A short demo about a view returning an error when it contains a native sql function.