780 reputation
1618
bio website sblackler.net
location Bournemouth, United Kingdom
age 24
visits member for 2 years, 9 months
seen Mar 31 at 11:05

I am a self-taught programmer originating from the Isle of Wight. I have approximately 3 years commercial experience in developing LOB applications for a wide range of customers (local companies to FTSE 100). During this time, I have honed my development skills across a wide range of platforms and frameworks including C#, VB.net, T-SQL, Web Services and Android programming.

I am currently training towards my MCSA SQL Server 2012 qualification alongside my degree in Computing from Bournemouth University (Graduating 2013). During my time at Bournemouth University, I have built an extensive knowledge in core networking protocols and architecture including TCP, IP (v4 & v6), DNS, ARP, HTTP, EMAIL (SMTP, POP3 and IMAP), WiMAX (802.16) and WiFi (802.11).


Aug
25
comment SQL Server Join/where processing order
Why is distinct..join bad? Links would be great, thanks (googling myself at the mo)
Aug
25
accepted SQL Server Join/where processing order
Aug
25
comment SQL Server Join/where processing order
Actually @Gbn has got it below :)
Aug
25
comment SQL Server Join/where processing order
That's what I was thinking of. I couldn't remember the exact details of it though, thanks. In the case of the SO question I mentioned in the original post (no indexes and not allowed to create them) then would something like my approach work do you think?
Aug
25
comment SQL Server Join/where processing order
Are you sure? I could swear that the processing of tables comes before anything else (eg. where), so in theory the two would generate two different query plans (although not always) At book i'm thinking of is at work so i'll edit the above tomorrow morning when I have had chance to double check my facts
Aug
25
asked SQL Server Join/where processing order
Aug
22
accepted SQL Server Service Broker and Deadlocks
Aug
22
comment SQL Server Service Broker and Deadlocks
thanks @gbn :).
Aug
22
comment SQL Server Service Broker and Deadlocks
thanks for this :) I thought as much, but it was a long session earlier and my brain is quiet functioning as it should ha!
Aug
22
comment SQL Server Service Broker and Deadlocks
Oh and could someone with enough rep create a "service-broker" tag please :) Quote from: msdn.microsoft.com/en-us/library/ms166071.aspx
Aug
22
asked SQL Server Service Broker and Deadlocks
Aug
21
accepted Health checking via Database Mail in SQL Server
Aug
20
accepted SQL Server Checklists
Aug
19
revised Health checking via Database Mail in SQL Server
added 351 characters in body
Aug
19
revised SQL Server Checklists
added 69 characters in body
Aug
19
asked SQL Server Checklists
Aug
19
asked Health checking via Database Mail in SQL Server
Aug
19
accepted Advice with date column SQL Server 2005
Aug
19
comment Advice with date column SQL Server 2005
Worked like a treat. Computed column + index = sub-second query :) Cheers
Aug
19
awarded  Commentator