1,017 reputation
1826
bio website sblackler.net
location Bournemouth, United Kingdom
age 24
visits member for 3 years
seen 4 hours ago

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).


May
22
comment Is it recommended to clear the query plan cache
Probably no more than 15% for this one query. Don't have access to the server at the moment to check
May
22
comment Is it recommended to clear the query plan cache
Not sure if you saw the edit I put on as you were writing but most of the top queries are like SELECT blah FROM t WHERE param = 1 then param = 2 and so on... Does that affect your answer? Sorry if it does, you were too quick :P
May
22
asked Is it recommended to clear the query plan cache
Apr
5
accepted CROSS APPLY-ing a parameterised function
Apr
4
asked CROSS APPLY-ing a parameterised function
Mar
28
awarded  Nice Question
Feb
15
comment Output into temporary table
Thanks. Fancy putting that in an answer :)
Feb
13
asked Output into temporary table
Jan
16
awarded  Nice Question
Dec
28
accepted Table value functions vs UDF SQL Server
Dec
28
comment Table value functions vs UDF SQL Server
Didn't see the duplicate :/ my bad
Dec
28
asked Table value functions vs UDF SQL Server
Nov
29
accepted Over use/correct use of schemas?
Nov
29
comment Over use/correct use of schemas?
I usually sort out permissions at the end of development as we have somewhat "fluid" specifications at times. Is this how you do it? Or do you assign permissions as you create the objects etc
Nov
29
comment How large is “too large” for SQL 2008 Web Edition?
Thanks for the links about the future licensing
Nov
29
asked Over use/correct use of schemas?
Nov
22
awarded  Citizen Patrol
Nov
10
accepted When should a primary key be declared non-clustered?
Nov
10
comment When should a primary key be declared non-clustered?
Excellent answer. Thanks :)
Nov
10
comment When should a primary key be declared non-clustered?
Thanks @BenBrocka that makes sense. What would be your recommendation if instead of having a country column, you would have another table for the countries (so the country column is now normalised)