meta user
network profile
| 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 | 33 |
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 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 |
|
Mar 28 |
awarded | Nice Question |
