I'm not sure why I love these pixtures...
American Pixels
Wednesday, January 20
Wednesday, December 23
Grouping SQL by month, week etc.
Excellent summary from Jeff Smith on how best to group data by time periods.
Quickhint:
If in doubt, the ‘go-to’ technique is to use
GROUP BY dateadd(month, datediff(month, 0, SomeDate),0)
replacing ‘month’ with any of:
- year
- quarter
- month
- dayofyear
- day
- week
- hour
- minute
- second
- millisecond
- microsecond
- nanosecond
Read the article for a great write up on the whys and wherefores and as always your mileage may vary – testing the various techniques with your own data is the only sure way of getting the performance you need.
Thursday, December 10
It’s good to talk
Whilst trimming your nose hair apparently….
Shopping for an answer machine, amazon was really helpful.

Tuesday, October 27
Thursday, October 22
You can't hide the eyes....

Idi Amin: Yes, you are my advisor. You are the only one I can trust in here. You should have told me not to throw the Asians out, in the first place.
Nicholas Garrigan: I DID!
Idi Amin: But you did not persuade me, Nicholas. You did not persuade me!
Wednesday, September 16
Michael Cena
Superbad – Awesome
Juno – Good
Youth in Revolt – Promising
Who didn’t want to have an alternate cool persona when they were teenagers/adults. Apart from me obviously. I’m cool enough as it is…
Tuesday, September 15
Subscribe to:
Posts (Atom)

