Useful tips for everyday
How do I Countif month and year? You can also apply this array formulas =SUM(IF(MONTH(B2:B15)=8,1)) (press Ctrl + Shift + Enter keys) to count birthdays…
Does order matter in non-clustered index? The column ordering in a composite Non-Clustered Index matters – when you have to perform Range Scans! Does the…
How big is a parallel sequential scan in PostgreSQL? For a parallel sequential scan, the amount of table data scanned is always equal to the…
How do you resolve redo log corruption? Solution Clear the archived group(corrupted) (alter database clear logfile group If could not clear archived redolog then clear…
How big is PostgreSQL database for admissions data? However, having PostgreSQL as the single source of truth about all data that is being aggregated and…
How change MySQL data file location? 4 Answers Shutdown mysql. Move all the files in your current data directory to the new location (check out…
How to extract JSON object field in PostgreSQL? Extracts n ‘th element of JSON array (array elements are indexed from zero, but negative integers count…
How big will the transaction log backup be? – Database Administrators Stack Exchange How large will the Transaction Log backup be? I encountered a production…
How do I move SQL data and log file? Make sure to move both ldf and mdf files In SSMS right click the Server and…
How do I access AWS RDS Oracle Database from local machine? Sign in to the AWS Management Console and open the Amazon RDS console at…