Monday, January 17, 2005 - Posts

User Defined Function performance comparison

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/User Defined Function performance comparison
The new RSS feed is here

For some time now I wanted a basic example that showed the impact of using functions (UDFs), I was looking at SQLServerCentral and saw a new piece on an LPAD function

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/User Defined Function performance comparison

posted Monday, January 17, 2005 10:43 PM by SimonSabin with 4 Comments

Virtual Server performance figures

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Virtual Server performance figures
The new RSS feed is here

I am trying to put together some stats on difference between different ways of doing something in SQL 2005, TSQL, SQLCLR etc and find some interesting results.

If the host machine (the one running Virtual Server) is doing something then the guest machine (i.e. the virtual server) doesn't get all its CPU cycles this therefore throws out any results. Occasionally I have had results that seem to defy time.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Virtual Server performance figures

posted Monday, January 17, 2005 12:35 AM by SimonSabin with 0 Comments