1,464 reputation
21225
bio website twitter.com/coder4hire
location Manchester, United Kingdom
age 38
visits member for 4 years, 2 months
seen Mar 23 at 10:14

Software developer and co-founder of Australian software company Redgum Technologies, been developing since late 80's in a variety of languages, C, C++, VB, .NET, etc... as well as a few niche ones...

Last few years Have been spending the majority of my time in SQL Server databases...


Mar
6
awarded  Famous Question
Feb
19
comment Why does SUM() return 0 when no rows in table?
@ypercube You're right, my mistake (I'd just deleted my comment because I was wrong)
Feb
19
revised Why does SUM() return 0 when no rows in table?
looked back on some emails I'd sent in the past and corrected my check, I've been saying If the value is still NULL handle it... (handles no rows as well as assigned NULL)
Feb
19
accepted Why does SUM() return 0 when no rows in table?
Feb
19
comment Why does SUM() return 0 when no rows in table?
My memory is that SQL Server 2005 and earlier used to not return any row if no GROUP BY was specified (a google and stackoverflow search indicates that other people had the same experience), do you know when/why it changed?
Feb
17
comment Why does SUM() return 0 when no rows in table?
Another related: dba.stackexchange.com/questions/25435/…
Feb
17
asked Why does SUM() return 0 when no rows in table?
Jan
17
awarded  Yearling
Oct
29
answered Currently all connections getting “Timeout expired”
Sep
23
awarded  Notable Question
Sep
4
comment Does SQL server 2008 log instance level security permission changes
Note: if the database had been restored your login may have been disabled (for that DB only) if it was restored from a different server (even if you have a valid login for that server)
Aug
23
awarded  Famous Question
Aug
7
revised How to tell what invoked a trigger in SQL Server?
brief reformat to move code into code section (was showing as part of the comment block)
Aug
6
awarded  Organizer
Aug
6
revised How to tell what invoked a trigger in SQL Server?
adding tag to include SQL Server
Aug
6
suggested approved edit on How to tell what invoked a trigger in SQL Server?
Aug
6
answered How to tell what invoked a trigger in SQL Server?
Jul
2
awarded  Curious
Feb
11
awarded  Nice Question
Jan
17
awarded  Yearling