Reputation
17,673
Top tag
Next privilege 20,000 Rep.
Access 'trusted user' tools
Badges
3 37 61
Newest
 Nice Answer
Impact
~1.7m people reached

Feb
11
comment Enabling the use of OPENROWSET in Sql Server
You've tagged this as data guard, but the question isn't about Oracle?
Feb
8
comment Error ORA-12505 when trying to access a newly installed instance of oracle-11g express
Is the oracleXE service running? Check in services.msc
Feb
8
comment Trouble With Basic Query Searching
Line 4 should have and instead of where. Also, other people will shout at you for not using new style ANSI joins
Feb
7
comment floating point exception in isql with mariadb
askubuntu.com/questions/446483/…
Feb
7
comment Prove or disprove that `T=R÷S` implies `S=R÷T`?
Simple maths? T=R/S multiply both sides by S: ST=R Divide both sides by T: S=R/T
Feb
5
comment How to check value when i have a list of elements separated by comma in a column?
Which RDBMS are you using?
Feb
5
comment Configure encryption in MariaDB specific to Windows/XAMPP
I don't see why the configuration would be any different on Windows vs Linux. Obviously you'd need a windows prog to generate the certificate, but it'd be silly to have the .ini config variables different, wouldn't it?
Feb
3
comment Mariadb uses all /tmp space
You are doing lots of large sorts (ORDER BY/GROUP BY etc ) that have to spill to disk, probably
Feb
3
comment Any way to view the list of commited transactions in a period of time?
Logminer. Best of luck with it
Feb
3
comment How to compare dates on minute level in plsql?
ROUND(yourdate,'MI')
Feb
2
comment COPY in TSV data enclosed by quotes; treat empty strings as NULLs
@kermit to the rescue?
Jan
28
comment Why does this PostGIS query take so long to run?
It is slower because rather than just reading the (presumably already cached) data, it's having to write it. It's going to be an order of magnitude slower
Jan
27
comment What service that lets you create records/data into an immutable database storage system that cannot be deleted?
Sounds like the Bitcoin blockchain.
Jan
26
comment Data obfuscation in SQL Server
You shouldn't be using MD5 in this day & age, it's inherantly insecure.
Jan
26
comment What is the best way to store SSH fingerprints and public keys?
Store it as a string. Over time you'll be dealing with different keys in different formats. May also want a key_type column or something.
Jan
25
comment When the query was last executed?
... because you don't have permission to view the table. Queries get aged out of v$sql anyway, so it may not help you
Jan
25
comment When the query was last executed?
There's no generic portable way of doing this across RDBMSes as they all have differing data dictionaries.
Jan
22
comment mysqldump collation issues
If you don't bother with charactersets and just do the export then import without even mentioning them, does it work? Just a bit worried you're trying to over complicate things
Jan
22
comment SQL to XML with multiple values
Which RDBMS? SQL Server, given the abundance of [][][]?
Jan
22
comment Select ONE most recent post for each author
Possible duplicate of How to select the line with the max(date)?