378 reputation
110
bio website
location United States
age
visits member for 2 years, 2 months
seen Feb 4 at 17:12

Jan
9
comment Which SQL standard is most broadly and completely supported?
@AaronBertrand Standard SQL is heavily used by a large % of developers. There are platform specific functions and tweaks, but the vast majority of work done (on MySQL, SQL Server, etc) is plain jane SQL. gbn says not to bother, then says to play with MySQL. Is that useful?
Jan
9
comment Which SQL standard is most broadly and completely supported?
"Standard SQL isn't used in the real world for paying jobs on successful projects..." -- silliest thing posted on all of stack exchange.
Jan
5
accepted SQL Server 2008: Measure tps / select statements per second for a specific table?
Dec
19
comment How to archive a transactional table on another server?
Thanks! I am a tad wary of transactional replication, because it sounds hairy (brentozar.com/archive/2013/09/… ). Can you even do a two-box implementation of transactional replication, or is it reqd to do 3 box?
Dec
19
revised How to archive a transactional table on another server?
added 81 characters in body
Dec
18
comment How to archive a transactional table on another server?
@ThomasStringer Yes, we want the archive table to include (keep) data that was deleted on prod. OP updated.
Dec
18
revised How to archive a transactional table on another server?
added 234 characters in body
Dec
18
comment How to archive a transactional table on another server?
@Kin OP enhanced
Dec
18
revised How to archive a transactional table on another server?
added 107 characters in body
Dec
18
asked How to archive a transactional table on another server?
Dec
16
comment SQL Server: How to get the responsiveness of a trigger, without blocking the transaction that fires the trigger?
@JackDouglas Hey, I think it should have stayed on hold. There is very little delta from the OP to now. The whole SE ecosystem is very negative, and puts holds on stuff very aggressively. Big turn off.
Dec
16
comment SQL Server: How to get the responsiveness of a trigger, without blocking the transaction that fires the trigger?
clr trigger.... means SQL Trigger --> CLR trigger --> external script. Interesting!
Dec
15
awarded  Peer Pressure
Dec
15
revised SQL Server: How to get the responsiveness of a trigger, without blocking the transaction that fires the trigger?
deleted 77 characters in body
Dec
15
revised SQL Server: How to get the responsiveness of a trigger, without blocking the transaction that fires the trigger?
added 167 characters in body
Dec
15
comment In SQL Server, how to launch a python script from an insert trigger?
@jcolebrand yes and no... iron python lets you run python in the CLR, and this appeared to be the way forward. But... it turns out that iron python code cannot be called from SQL CLR... stackoverflow.com/q/20584374/147637
Dec
13
revised SQL Server: How to get the responsiveness of a trigger, without blocking the transaction that fires the trigger?
added 140 characters in body
Dec
13
revised SQL Server: How to get the responsiveness of a trigger, without blocking the transaction that fires the trigger?
added 140 characters in body
Dec
13
asked SQL Server: How to get the responsiveness of a trigger, without blocking the transaction that fires the trigger?
Dec
13
comment In SQL Server, how to launch a python script from an insert trigger?
Can we mellow out a small bit? I am just trying to see if the community can help me solve a puzzle. I am not claiming the puzzle is a good puzzle, but I do need it solved, and I appreciate constructive guidance.