Reputation
4,126
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
7 20
Newest
 Constituent
Impact
~404k people reached

Aug
5
awarded  Constituent
Aug
4
awarded  Yearling
Jul
28
reviewed Approve Finding all date ranges that overlap a target date range
Jul
28
reviewed Approve Use of log_bin_trust_function_creators in MySQL
Jul
28
reviewed Approve SQL Server : create dynamically queries to select all related data in DB based on entry table and ID
Jul
28
comment SQL Server : create dynamically queries to select all related data in DB based on entry table and ID
So, in short, you want to essentially return the source row, plus related rows from other tables for the same record? Correct? Can you guarantee that each table will only have a single unique-identifier column? Or do you know the name of the source column upfront?
Jul
28
awarded  Caucus
Jul
19
comment When does a MySQL session end?
What is the value of your max_allowed_packet variable?
Jul
19
answered Microsoft Help Viewer in ssms 2014 doesn't open local documentation
Jul
16
answered When to prefere a truncate over a batch-delete?
Jul
16
comment Microsoft SQL Server partitioning with on premise server
What reason did they give for wanting the data onsite?
Jul
9
comment CLR/C# equivalent to XACT_STATE()
Yes, it does. You would need to check it after each command executed against the transaction but the SqlClient library can handle dead transactions perfectly fine - indeed, there is even a method titled "TransactionEndedByServer" which handles this specific scenario.
Jul
9
answered CLR/C# equivalent to XACT_STATE()
Mar
16
reviewed Approve Need help achieving HAProxy active/passive configuration for mysql
Mar
9
reviewed Approve PHPMyadmin transactions not commited
Nov
4
reviewed Approve Return rows one at a time from variable table
Sep
30
awarded  Explainer
Aug
4
awarded  Yearling
Jul
22
comment SQL Server 2000 : Upgrade from Personal Edition to Enterprise Edition
Sometimes you are bound by third parties, or corporate decision makers. We have some critical systems still running on DOS, why I hear you ask... well because they work. Sometimes you don't have a choice.
Jul
17
reviewed Approve Trouble quering a join in oracle sql