1,072 reputation
11029
bio website sblackler.net
location Bournemouth, United Kingdom
age 25
visits member for 3 years, 5 months
seen Nov 25 at 10:51

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
29
asked Strange behaviour with Computed Columns in SQL-Server
Aug
26
comment What are the performance implications of running multiple smaller DBs instead of a single larger DB on a server?
How big are the databases? How many concurrent users of the system are there?
Aug
25
comment SQL Server Join/where processing order
Thanks for the links. Once I get it clear how it work's I hope I will write better queries etc :)
Aug
25
comment SQL Server Join/where processing order
Thanks for the link. Once I get it clear how it work's I hope I will write better queries etc :)
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