-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: July 2015

The SQL Saturday Crazy Train hooks up a caboose!

You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get going and bang! The times up. There’s only so much material that can be presented in just one hour. And if there are a lot of questions, you may… Read more

0 comments, 547 reads

Posted in A Discussion of SQL Server-Related Topics on 20 July 2015

How do different types of functions compare performance wise?

A while back, I wrote a blog post showing the differences (including performance) between Inline Table-Valued Functions (ITVF) and Multi-Statement Table-Valued Functions (MSTVF). Since then, whenever I speak about ITVFs / MSTVFs, I’m frequently asked about how Scalar Functions (SF) perform. My stock answer has always been that they perform… Read more

1 comments, 642 reads

Posted in A Discussion of SQL Server-Related Topics on 16 July 2015