Question : We have a relatively classic scenario where the date clause of the query generated by the application uses […]
Author: admin
Determine databases specified Login has access to on SQL Azure
Question : I need to obtain a list of all the databases a specific user has access to. To this […]
What is the performance overhead of IFNULL in the select statement of mysql 5.7+ query
Question : I’ve recently made an upgrade to a mysql query performed by my web server when serving request. There […]
ROLLBACK TRAN
Question : Answer :
Maximum length or special character restrictions for PostgreSQL 13 user password?
Question : I’m using a password generator to come up with a password that will be automatically pulled from Azure […]
SQL Server Express Edition feature and upgrade concerns
Question : I want to install and learn T-SQL with SQL Server. The lightest edition that I can find is […]
Why is LIMIT killing performance of this Postgres query?
Question : I have a Postgres materialized view: Column | Type | Modifiers ———————+——————-+———– document_id | character varying | recorded_date […]
Two backup programs, diff and log out of sync
Question : I am running encrypted backup on SQL Server 2017. Doing a test restore, it failed: RESTORE DATABASE [test] […]
Count and sum, counted and summed values
Question : I know the title is a bit mysterious. I just would like to ask how I can optimize […]
Why the WHERE clause is not pushed down in the view’s query?
Question : With Postgres 9.4, I’m doing the following query quite often: SELECT DISTINCT ON(recipient) * FROM messages LEFT JOIN […]