Related Articles
Index selectivity & queries with multiple equality conditions
Performance of a query having multiple equality type predicates improves as it switches from using the index on an unselective column to a selective one. It is very common to issue queries with multi...
#0401 – SQL Server – Script to validate object naming convention
When database development is done using the graphical (GUI) tools in the SQL Server Management Studio (SSMS) or via simple scripts, they often fail to specify a name to each individual constraint. Thi...
Predicting IBS in Dogs using Oracle 18c in the Cloud
Over the past 6-8 months I've been working on a project with the Veterinary School of Medicine, part of University of Dublin. The project was focused on using Machine Learning to find patterns in bloo...
