Reputation
Next tag badge:
96/100 score
33/20 answers
Badges
11 85 191
Newest
 Guru
Impact
~7.4m people reached

Jun
26
reviewed No Action Needed SQL Server Management Studio greyed out
Jun
26
reviewed No Action Needed Unnest multiple arrays into rows
Jun
26
reviewed Close Is there a standard for naming foreign keys when two columns reference the same table?
Jun
26
revised Cannot delete MySQL trigger. Appears in information_schema, but no .TRN file
added 1 character in body; edited tags
Jun
26
answered Cannot delete MySQL trigger. Appears in information_schema, but no .TRN file
Jun
26
reviewed No Action Needed msdb.dbo.sp_start_job got stuck in stored procedure
Jun
26
reviewed Close How to convert timestamp to string in Pentaho Kettle?
Jun
26
reviewed Close Kibana-like tool for PosgreSQL
Jun
26
reviewed Close Reorganize Index Task
Jun
26
reviewed Close ERROR 1166 (42000) at line 65203: Incorrect column name ''
Jun
26
reviewed Close http vs sql queries
Jun
26
comment MySQL loading NULLs in numeric columns
I was keeping the same table structure to reload and try again but with \N. If you look at the workaround in the bug report, there is a truncate bug_repeat; befoe the second LOAD DATA INFILE attempt. Thus, I was trying to duplicate the test of the workaround.
Jun
26
reviewed Close How can I write a query to aggregate multiple strings into one field?
Jun
26
reviewed Close Data dump from Mongo to CSV
Jun
26
comment MySQL loading NULLs in numeric columns
With regard to LOAD DATA INFILE, yes, it's the only way. Otherwise, numeric values that follow the IEEE floating point format become 0. Since I pointed out the workaround (dba.stackexchange.com/questions/87206/…), no has created an IEEE floating point datatype that can start out as NULL.
Jun
26
reviewed No Action Needed Partitioning existing table in Oracle
Jun
26
reviewed No Action Needed Possible to detach a database from SQL Server while retaining file permissions?
Jun
26
reviewed Looks OK How to use PostgreSQL bit_or function to aggregate column?
Jun
26
reviewed Close Keep connections alive when disconnected from network
Jun
26
reviewed Close Create database in SQL Server 2014