Useful tips for everyday
What is a report ID? The report ID is the report technical name which lies underneath the UI name, it is unique and provides some…
How to resolve mysqldump errors on Amazon RDS? Your target RDS DB instance has the binary log enabled ( backup retention period > 0), and…
How do I change user in PostgreSQL? Change default PostgreSQL passwords Connect as ubuntu to the instance where PostgreSQL is installed. Switch to the root…
Do you have to have a partitioning column in a clustered index? If the clustered index is unique, you must explicitly specify that the clustered…
What happens when I change the name of my SQL Server? When you change the name of the computer that is running SQL Server, the…
Can a Bulk insert be used in SQL Server? For the user to be able to use BULK INSERT or OPENROWSET to import data from…
How do I add more than 8000 characters in SQL? SQL SERVER – How to store more than 8000 characters in a column Step 1…
What value should be used for Maxdop? MAXDOP should be no more than the number of cores available to the SQL Server instance. So if…
What is the storage engine for PostgreSQL? one storage engine PostgreSQL has one storage engine; MySQL has nine, but only two of those really matter…
How do I get distinct on more than one column? DISTINCT on multiple columns Sample Select statement. Select with distinct on two columns. Select with…