Column order can matter
Ordinarily, column order of a SQL statement does not matter.
Select a,b,c
from table
will produce the same execution plan as Select c,b,a
from...
2011-06-06
2,170 reads
Ordinarily, column order of a SQL statement does not matter.
Select a,b,c
from table
will produce the same execution plan as Select c,b,a
from...
2011-06-06
2,170 reads
At the Kent user group we have two upcoming events. Both are to be held at F-Keys Training suite http://f-keys.co.uk/...
2011-06-05
636 reads
Thanks to those who turned out to see my presentation at SqlHerts on Thursday 26thMay. Its a true pleasure to...
2011-05-29
1,330 reads
If you are in anyway interested in SQL Server and live in the UK, you cant of failed to of...
2011-04-11
688 reads
If you’ve answered yes to both of those questions , Jacob Sebastian has some more question for you.
Every day in March...
2011-03-12
536 reads
I am not a lawyer. Let me say that again, I am not a lawyer.
Todays Dilbert has prompted me...
2011-02-24
807 reads
In my previous post “Denali Paging – is it win.win ?” I demonstrated the use of using the Paging functionality within Denali. ...
2010-11-19
680 reads
I'm not one for automatically poo-pooing new ideas, new practices and new technology. Rather I like to take a measured...
2010-11-10
787 reads
Greg Gonzalez (blog | twitter) of SqlSentry, last night released a very cool new and free product. Plan explorer is a...
2010-10-21
2,893 reads
In a previous blog entry (Inconsistent NullIf behaviour), Jeff Moden and Dan Halliday(twitter) both made a very similar observation.
When executing...
2010-09-06
534 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers