Reputation
12,552
Next tag badge:
733/1000 score
223/200 answers
Badges
7 32 59
Newest
 sql
Impact
~668k people reached

May
12
reviewed Leave Open Statement succeeds, data missing
May
12
comment how many tables do i need to create in MYSQL
I'm voting to close this question as off-topic because we don't know what your boss wants from you.
May
11
comment Postgresql performance issues when issuing many small inserts and updates one at a time
How your setup does look like? Are the two servers on the same machine? VMs involved? What sort of disks are there? And what do you see when you monitor the DB activity during the update/insert time?
May
11
comment Put Postgres query result in array
I've just made a small test where I see the two producing the exact same query plan, therefore the same execution time.
May
11
comment Combining separate ranges into largest possible contiguous ranges
@ErwinBrandstetter yes, that's an issue I wanted to test (after my first extreme was 9999-12-31 :). At the same time, I am wondering why my answer has more upvotes than yours. This is possibly easier to understand... So, future voters: Erwin's answer is superior to mine! Vote there!
May
10
comment Postgres automatic insert time stamp with time zone (india)
@0x54MUR41 You don't have to be sorry. If every first-time poster spent this much energy on their post, this site would be even awesomer :) You see, you got some nice upvotes for a reason.
May
10
comment Speed up SELECT with WINDOW, (PARTITION … ORDER) with compound index
Is this an actual problem? The query runs in under a millisecond...
May
9
comment Combining separate ranges into largest possible contiguous ranges
@ErwinBrandstetter that won't really work with generate_series() :)
May
9
comment Postgres automatic insert time stamp with time zone (india)
With which part do you have the problem? What sort of query do you want to insert? Are your servers have proper time zone settings? And finally, what do you mean by desired time format?
May
9
comment Postgres automatic insert time stamp with time zone (india)
I think you slightly overthought the problem - in my understanding, they just want to have a timestamp with every row inserted.
May
9
reviewed Leave Closed Hiding server folders for specific user in SQL Server Management Studio
May
9
reviewed Close Mysql date_add returns wrong row in python, right row in phpmyadmin
May
9
reviewed No Action Needed Backup Error (.bak)
May
9
reviewed Reviewed Mysql Select Categories and count of sub items
May
9
revised postgres fetch record from partitions without the check constraints
added 154 characters in body
May
9
answered postgres fetch record from partitions without the check constraints
May
8
reviewed Approve what is causing Errors running from Localhost
May
8
revised SQL Server 2008 R2 - Unable to delete Login
edited tags
May
8
reviewed Close Is it possible to change the default style used by CAST/CONVERT when converting DATETIME?
May
8
reviewed Close Does AWS Aurora suffer from the same limitations that MySQL suffer from?