Why is Data Quality important
The SQL Mind Team In recent years, Data quality is becoming more and more crucial for companies and business around the world
Finding duplicates in SQL Server
In a single column: To get duplicates on a specific column, you can use the GROUP BY and COUNT(*) statements. For example, to find duplicates on the “ModifiedDate” column of…
How to search for objects on all the SQL Server databases
You can seach for objects in all the SQL Server databases within one instance by using the built-in stored procedure: sp_MSforeachdb. For example, let say that you are looking for…
How to find queries, stored procedures and parameter’s values using SQL Profiler
Have you ever faced the problem that you want to see that query or stored procedure that was executed from the front-end application, but you are not able to see…
How to get the current running queries in SQL Server
To get the list of current running queries, you can use the following script:
How to insert into a one column (identity) table
Tables with just one column, which has been specified as identity columns, are not very common, and inserting data into them might be a bit tricky. To do that you…