47,826 reputation
470125
bio website
location Malta
age 45
visits member for 3 years, 9 months
seen 3 hours ago

aka Shawn

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

4h
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
4h
answered How to get statement which causes error 3609?
4h
comment Transaction Isolation level different threads massive number of Writes
Isolation Level will not help you. Yes use a stoerd procedure
4h
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.
4h
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
Aug
14
awarded  Nice Answer
Aug
8
comment SQL Server 2000 Backup fails with Status = 33
Given the age of this server, are you using FAT32? That is, hitting filesize limits?
Aug
8
comment Microsoft SQL Server Connection Coloring
Perhaps this can be sorted via security to restrict production access?
Aug
8
comment SQL cache hit ratio
Personally, I'd want a higher value if possible...
Aug
7
reviewed Close mysql server is not starting
Aug
7
answered Does it make sense to order condition in where query?
Jul
2
awarded  Curious
Jun
17
awarded  Generalist
May
21
comment Why is the speed of executing statements dependent on the network connection?
Se this answer on my question too please stackoverflow.com/a/1547539/27535
May
2
comment Is there a common approach to encrypting data at the database level?
Following on from Jon's comment, are you suggesting that each user has a different encryption key? Are you actually asking about row level security a.k.a filtering to the rows a user can see.