Stuart Blackler

690 reputation

316

bio	website	sblackler.net
	location	Bournemouth, United Kingdom
	age	23
visits	member for	1 year, 10 months
	seen	Apr 17 at 1:35
stats	profile views	34

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

	690 reputation	bio	website	sblackler.net	visits	member for	1 year, 10 months
316 badges		location	Bournemouth, United Kingdom		seen	Apr 17 at 1:35

summary answers questions tags badges favorites bounties reputation activity

46 Comments

suggestions reviews revisions comments badges posts accepts all

Dec 16	comment	Difficulty in finding Candidate Keys re-tagged as homework
Dec 13	comment	DELETE vs TRUNCATE A very complete answer, thank you. Extremely helpful. May I ask what you mean by an extent?
Dec 13	comment	DELETE vs TRUNCATE Thanks for all the links to the other questions all :)
Dec 8	comment	case versus isnull versus coalesce Thanks for the complete answer so quickly. I had no idea that the order of precedence mattered for `COALESCE`. Thanks again
Dec 8	comment	case versus isnull versus coalesce related I agree. but not dup. Thanks for the comment :)
Nov 29	comment	When should a primary key be declared non-clustered? there are only two other answers to read... thanks for your time to answer mind.
Jul 15	comment	Tempdb autogrowth settings Got that down on my to-do list. Sys-admins are going to love me on Tuesday when im back in the office :D Thanks for the link.
Jul 15	comment	Tempdb autogrowth settings Yes it does, thanks for the insight. :)
Jul 15	comment	Tempdb autogrowth settings Typically in the environments I work in, SQL Server is generally placed on a multi-purpose server. So SBS might be on the box as well so I have to keep these things in mind. I am definitely an accidental dba (developer by trade) and your comments are much appreciated. I will have to come up with sensible defaults for each environment. Thanks
Jul 15	comment	Tempdb autogrowth settings Thanks for the links. It would be great if that trace flag could be configured for just one database
May 28	comment	Does SQL Server evaluate functions once for every row? Thanks for the link and explanations :)
May 23	comment	Is it recommended to clear the query plan cache Thanks for the discussion guys. It's been most helpful :)
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
Feb 15	comment	Output into temporary table Thanks. Fancy putting that in an answer :)
Dec 28	comment	Table value functions vs UDF SQL Server Didn't see the duplicate :/ my bad
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 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)