48,066 reputation
473129
bio website
location Malta
age 45
visits member for 3 years, 10 months
seen Nov 20 at 16:00

aka Shawn

  • SQL Server Developer/DBA
  • MySQL Developer
  • British expat
  • Code monkey

2d
awarded  Enlightened
2d
awarded  Nice Answer
Nov
12
awarded  Nice Answer
Nov
7
awarded  Enlightened
Nov
7
awarded  Nice Answer
Nov
7
answered Change Data Types large Live table
Nov
6
awarded  Enlightened
Nov
6
awarded  Nice Answer
Oct
26
comment T-SQL Parsing XML escaped in format %3E (less than)
First off, convert this to XML usign a DecodeURL SQL or CLR function. Then it is standard XML parsing
Oct
26
reviewed Close SQLCMD.exe in SQL Server 2012 does not give real-time output logging
Oct
23
comment Transaction Isolation level different threads massive number of Writes
How would the trigger on first table know what data is to go into the second table? A stored procedure does the same with more visibility
Oct
23
answered How to get statement which causes error 3609?
Oct
23
comment Transaction Isolation level different threads massive number of Writes
Isolation Level will not help you. Yes use a stoerd procedure
Oct
23
comment SQL database disaster recovery in a second datacenter using storage
Are you using Enterprise or Standard edition of SQL Server? If standard, your options are limited of course.
Oct
23
answered Transaction Isolation level different threads massive number of Writes
Sep
30
awarded  Explainer
Sep
16
awarded  Enlightened
Sep
16
awarded  Nice Answer
Sep
5
awarded  Enlightened
Sep
5
awarded  Nice Answer