- Published on
- Authors
- koskila
How to form a parameterized SQL query to find duplicates in a table.
So one day, I needed to quickly check if an identity field in a view in a Microsoft SQL Server was actually unique or not....
sql-query
Blog posts tagged by sql-query
- Published on
- Authors
- koskila
How to verify connection to the database in Entity Framework Core?
This article explains how to perform a very simple and lightweight database connection test for an existing database context....
- Published on
- Authors
- koskila
How to clean up duplicates from MS SQL Database?
This article explains how to query and remove duplicate entries from a Microsoft SQL database using T-SQL....
- Published on
- Authors
- koskila
Easily querying all the database and log file sizes on SQL Server
Quite often you get the need to simply quickly query all the database sizes on MS SQL Server....