431 reputation
2520
bio website blog.zygonia.net
location Perthshire, Scotland
age 47
visits member for 3 years, 5 months
seen Oct 29 at 18:39

About Me:

I work as a professional software developer for a UK web hoster and internet services company and spend most of my time building provisioning and web based self-service systems for IIS, Apache and Citrix XenServer.

My Curriculum Vitae can be viewed on Stack Overflow Careers.

Stuff I like to listen to at last.fm

You can get in touch here: kevin #.# kenny #@# zygonia #.# net (you know what to do with the # and spaces).

Have rejoined this Facebook nonsense so come and abuse me here: https://www.facebook.com/kevin.kenny.12


Sep
30
awarded  Explainer
Aug
11
awarded  Popular Question
Jul
2
awarded  Curious
Jun
10
awarded  Popular Question
May
11
awarded  Notable Question
Mar
31
awarded  Yearling
Feb
26
awarded  Popular Question
Feb
6
awarded  Famous Question
Feb
1
awarded  Popular Question
Jan
23
comment Why does CAST(1 AS SIGNED INTEGER) return a BIGINT on MySQL?
@Phil - yeah I read that too, and indeed that behaves as expected i.e. doing SELECT 1+1 results in a BIGINT. But it still doesn't explain away why CAST() behaves contrary to the documentation (as I understand it) and produces a BIGINT even if asked to cast to SIGNED INTEGER or UNSIGNED INTEGER on a single scalar value.
Jan
23
comment Why does CAST(1 AS SIGNED INTEGER) return a BIGINT on MySQL?
@Phil - I did read that over and over. Why does it say SIGNED [INTEGER] in the section The type for the result can be one of the following values:. Is a SIGNED INTEGER in the context of a CAST not in fact a 32 bit integer?
Jan
23
asked Why does CAST(1 AS SIGNED INTEGER) return a BIGINT on MySQL?
Jul
26
awarded  Popular Question
Jun
28
awarded  Nice Question
Mar
21
awarded  Notable Question
Jan
11
awarded  Popular Question
Dec
11
accepted Downgrading SQL Server 2008 R2 Standard to Web Edition
Dec
11
comment Downgrading SQL Server 2008 R2 Standard to Web Edition
That's pretty much the conclusion I was coming to. I was hoping to avoid having to uninstall Standard then re-install Web Edition. Thanks for confirming this.
Dec
11
asked Downgrading SQL Server 2008 R2 Standard to Web Edition
Dec
1
comment Recommended page file size for SQL 2008R2 on Windows 2008R2
@SQLKiwi - thanks for the info.