Data Tips and Solutions
Sorting a dataset by a criteria is an important operation. It is an interesting way to start analyzing different datasets by playing with the data around. If you are migrating from SQL this would be the equivalent of the “ORDER BY” clause. For this example … “How to sort DataFrames in Pandas”
Read More
Deleting temp tables is a simple job, but when we create tons of them and we would like to delete all without disconnecting our session from Sql Server, that can be a little tricky. For this example we are going to use the following code … “How to drop all temp tables sql server”
Read More Fastest way to delete massive records in Sql Server When working with data one of the typical things to do is to delete records. This task can be completed easily by using DELETE statement but when data have millions of records and relation with other … “How to delete large number of rows in Sql Server”
Read More As data analyst, one common thing to do in our scripts, specially for creating a table is to check if that table already exist.
Read More How to set a default value for an existing column in Sql Server Updating a default value for an existing column is not as simple as execute a query, you have to consider a few things before doing it. We are going to see how … “How to set a default value for an existing column in Sql server”
Read More