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 | 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).
|
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 |
|
Aug 19 |
asked | Health checking via Database Mail in SQL Server |
|
Aug 19 |
accepted | Advice with date column SQL Server 2005 |
|
Aug 19 |
comment |
Advice with date column SQL Server 2005 Worked like a treat. Computed column + index = sub-second query :) Cheers |
|
Aug 19 |
awarded | Commentator |
|
Aug 19 |
comment |
Advice with date column SQL Server 2005 please may you see the updated question for my reasoning for CTE and clarification on the original question. I thank you for you work so far :) |
|
Aug 19 |
comment |
Advice with date column SQL Server 2005 please may you see the updated question for my reasoning for CTE and clarification on the original question. I thank you again for you work so far :) |
|
Aug 19 |
revised |
Advice with date column SQL Server 2005 added clarification |
|
Aug 18 |
comment |
Advice with date column SQL Server 2005 Slight problem in that your table t only has one date column (sorry if i wasn't clear on this). Mine has a start date and an end date. So I don't think it would work ? i'll try it. I've added my CTE version of your two cte's to the OP. Check it out. |
|
Aug 18 |
awarded | Editor |
|
Aug 18 |
revised |
Advice with date column SQL Server 2005 Added actual recursive query |
