Browse by Tags

Using a UDF as a SARG. Make a hash of it!

I am somewhat uncomfortable blogging this, as I feel that it falls into “Polish a turd” category. Having said that, it is a particularly ugly turd and it does polish up rather well. Though as the saying goes, it is still a turd. The evils and inadequacies of UDF (User Defined Functions) in SqlServer...

Posted to SQL and the like (Weblog) by Dave Ballantyne on Fri, Jul 2 2010
SQL 101 : Without “ORDER BY”, order is not guaranteed.

It’s as simple as that. If you don’t specify ORDER BY, then the order of your result set is not guaranteed. Oh sure , there may be situations where the data looks like it is being returned ordered, but this is not really the case. So, for example : CREATE TABLE #Example ( row_id INTEGER ); GO INSERT...

Posted to SQL and the like (Weblog) by Dave Ballantyne on Sun, Jun 27 2010

Page 1 of 1 (2 items)

SQL Server Blogs