Useful tips for everyday
What is a Rowstore index? In SQL Server, rowstore refers to a table where the underlying data storage format is a heap, a clustered index,…
How do I backup and restore a single table in mysql? MySQL Workbench allows you to make a backup of a single database table using…
Why do I have to rebuild Index in SQL Server? SQL Server 2016 implemented major performance improvements for these index operations. Also, in earlier versions…
How left outer join will work? A left outer join is a method of combining tables. The result includes unmatched rows from only the table…
What are the effective permissions the user will have? Effective Permissions is the cumulative permissions a user has for accessing a resource based on his…
How do you create a recommendation in Python? Build your recommendation engine with the help of Python, from basic models to content-based and collaborative filtering…
How do you find outliers in SQL? A fast way to identify outliers is to sort the relevant values in both ascending and descending order.…
How do you do unsupervised clustering? K-means is one of the simplest unsupervised learning algorithms that solves the well known clustering problem. The procedure follows…
How do you impute missing values with Knn? The idea in kNN methods is to identify ‘k’ samples in the dataset that are similar or…
What is the purpose of normalizing variables? The point of normalization is to make variables comparable to each other. The reason this is a problem…