Reputation
8,942
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
4 23 48
Impact
~451k people reached

Aug
5
reviewed Reviewed I have to replace file but an error
Aug
5
reviewed Reviewed Where does the logins users are stored in the SQL server “in which data base “
Aug
5
reviewed Close MySQL Connector C++ bad_alloc thrown?
Aug
5
reviewed Close Join duplicates on T-sql
Aug
5
reviewed Reviewed Checksum mis-match found on a table while restoring data using mysqlbackup
Aug
5
revised Checksum mis-match found on a table while restoring data using mysqlbackup
deleted 6 characters in body; edited tags
Aug
5
reviewed No Action Needed What is the best way to find out the sum of a field from a table?
Aug
5
reviewed Reviewed Efficiently computing aggregate functions over subqueries with incremental data
Aug
5
reviewed Reviewed Recursive BOM (Bill Of Material) type query
Aug
4
revised Why seq-scan can be much faster than index-scan and index-only-scan in this simple query?
added 202 characters in body
Aug
4
comment Why seq-scan can be much faster than index-scan and index-only-scan in this simple query?
Hm, now I found an excellent post from Robert Haas, where he describes these in detail. I have to admit you are right - index-only scans are not always index-only, but they try as long as it is possible. At the same time, an index-only scan with additional heap fetches is possible when a sufficient portion of the table pages remains unchanged since the last vacuum.
Aug
4
reviewed Close Dynamic Filters in SQL server
Aug
4
reviewed Close Inserting emoji - smartphones in MySQL database with PHP?
Aug
4
revised How do I list all tables in all schemas owned by the current user in Postgresql?
added 5 characters in body
Aug
4
revised Aggressive Autovacuum on PostgreSQL
added 8 characters in body
Aug
4
reviewed No Action Needed How to import a varbinary(max) column with bulk import?
Aug
4
reviewed Reviewed How To Manage Random Data Without Repitition?
Aug
4
comment How To Manage Random Data Without Repitition?
Please format your tables properly, it's not very easy to follow this way.
Aug
4
reviewed Reviewed Real-world scenarios for table with DENY SELECT and GRANT [INSERT/UPDATE/DELETE]
Aug
4
reviewed No Action Needed How can I call a remote User Defined Function?