1,000 reputation
1824
bio website sblackler.net
location Bournemouth, United Kingdom
age 24
visits member for 3 years
seen 2 days 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).


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
accepted Tempdb autogrowth settings
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
Jul
15
asked Tempdb autogrowth settings
Jul
11
accepted Safely moving and creating new tempdb files
Jul
11
asked Safely moving and creating new tempdb files
Jul
6
awarded  Yearling
Jun
8
awarded  Constituent
Jun
8
awarded  Caucus
May
28
comment Does SQL Server evaluate functions once for every row?
Thanks for the link and explanations :)
May
28
accepted Does SQL Server evaluate functions once for every row?
May
28
asked Does SQL Server evaluate functions once for every row?
May
23
accepted Is it recommended to clear the query plan cache
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
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