Useful tips for everyday
Why is Postgres using seq scan instead of index? If the SELECT returns more than approximately 5-10% of all rows in the table, a sequential…
Can a clustered index have included columns? 2 Answers. The reason for this is that when you apply a clustered columnstore index to a table,…
Why am I getting more rows after LEFT join? Left joins can increase the number of rows in the left table if there are multiple…
How to select group from table with Max date? SELECT group, date, checks FROM ( SELECT *, max_date = MAX(date) OVER (PARTITION BY group) FROM…
What is the password characters length in Postgres? The maximum length allowed for the user name and password is 63 characters. What is the maximum…
How do I prepare for a machine learning interview? Machine Learning Interview Practice Predict rain, identify fish, detect plagiarism. Reduce data dimensionality and explore how…
Does machine learning come under software engineering? Most machine learning is implemented in Python, while software development is spread across a large number of languages.…
How to adjust the bounding box of a map? In the following example I first store the bounding box of the NC map, then extend…
What is Bayes classification? Bayesian classification is a probabilistic approach to learning and inference based on a different view of what it means to learn…
How can I get cross validation results? k-Fold Cross-Validation Shuffle the dataset randomly. Split the dataset into k groups. For each unique group: Take the…