226 reputation
26
bio website adathedev.co.uk
location United Kingdom
age 32
visits member for 2 years, 9 months
seen Aug 11 at 12:56

C# & SQL Server Dev with a dash of NoSQL, Blogger


Jan
7
awarded  Notable Question
May
29
comment Should I be regularly shrinking my DB or at least my log file?
To add further resources to this, as to why shrinking your data files is harmful, there's a good set of further links here: brentozar.com/archive/2009/08/…
Jan
4
awarded  Yearling
Dec
6
awarded  Popular Question
May
15
answered Does Sql Server 2008 support Database Sharding
Apr
20
awarded  Supporter
Apr
20
comment Handling growing number of Tenants in Multi-tenant Database Architecture
+1 - pretty much exactly the same approach as I've used before. ~ same number of tenants too, worked really well.
Mar
22
comment Scalar function used in calculated column, what's the cleanest way to update the function?
Agree with the above comments. Thought there might have been scope for SYNONYMs to offer some help here (reference a SYNONYM in the computed column) - but you can't ALTER a synonym once created to "redirect" it to another object.
Feb
1
awarded  Editor
Feb
1
comment sp_send_dbmail with attachment
Thanks. I've tried per updated notes in my question, but still get an error
Feb
1
revised sp_send_dbmail with attachment
added 402 characters in body
Feb
1
awarded  Student
Feb
1
asked sp_send_dbmail with attachment
Jan
22
awarded  Teacher
Jan
4
awarded  Autobiographer
Nov
28
comment SQL Server commands to clear caches before running a performance comparison
+1 for combination of those 2 DBCC commands, and for relevance of "hot cache".
Apr
23
answered Should I be regularly shrinking my DB or at least my log file?
Feb
4
comment query plan caching (sql server)
+1 for main points + article
Feb
4
answered query plan caching (sql server)