Data Mining Workflow

A prerequisite for any data mining project is to understand data flows. The process illustrated below has five basic steps: Pull data Prepare data Split data into training and test sets Train the model Evaluate model Pull Data The data…

In-database Analytics with SQL-Server and R

Starting with SQL server 2016 we can now run our advanced statistical models right where the data lives. The increased proximity increases the efficiency of the resource intensive computations. It’s also a nice feature for developers who want to…

Align TempDB Files with Core Count

If you're suffering from tempDB contention then it may be time to add files to tempDB. The rule of thumb is to have one file per logical processor on servers with <= 8 logic procs. For severs with more than…

O.S. Configuration Performance Tip

Windows O.S. gives active applications priority over processes by default when assigning threads for execution. This is great for workstations but might not be optimal for database servers. One should periodically review the setting to ensure appropriate environment configuration.…

Index Tuning - Choosing the Best Key Order

When developing indexes to support queries it's important to pay attention to order of the key columns in the index key list. An important factor for determining key order is the type of operator used in the predicate e.g.…

Privacy Policy