Browse by Tags
All Tags »
Optimizer »
SQL Server (
RSS)
In my previous post “ Denali Paging – is it win.win ? ” I demonstrated the use of using the Paging functionality within Denali. On reflection, I think i may of been a little unfair and should of continued always planned to continue my investigations...
I'm not one for automatically poo-pooing new ideas, new practices and new technology. Rather I like to take a measured view and try to evaluate based upon merits. One of the new features in Denali is paging which is now supported by the FETCH option...
Greg Gonzalez ( blog | twitter ) of SqlSentry , last night released a very cool new and free product. Plan explorer is a tool for examining query plans and overcomes many of the limitations of viewing plans within Management studio. If you...
In a previous blog entry ( Inconsistent NullIf behaviour ), Jeff Moden and Dan Halliday ( twitter ) both made a very similar observation. When executing this code Code Snippet select top ( 10 ) abs ( checksum ( newid ()))% 4 from sys . objects the only...
NullIf can be a very handy function sometimes. For those who have not used it, if the result of the two parameters are equal then null is returned. So if we execute : Code Snippet Select nullif ( 10 , 10 ) as Result1 Select nullif ( 10 , 9 ) as Result2...
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...
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...
Sql Server is great at producing and caching efficient query plans. However these plans may not be the most efficient based upon the parameters passed into subsequent calls off a stored procedure. In this article I am assuming that you have read...