Finding duplicates in SQL Server
The SQL Mind Team 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…
T-SQL
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 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…