- 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....
ms-sql-server
Blog posts tagged by ms-sql-server
- Published on
- Authors
- koskila
"Conversion overflow" when reading numeric data from MS SQL database using Entity Framework
This article explains how to fix a weird situation where your .NET application utilizing EF (Entity Framework or Entity Framework Core) simply crashes without any way to recover or catch the Exception....
- 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
How to connect to your local MSSQL server using SSMS?
Every now and then you run into a situation, where you really need to run some SQL against your local development database. That database, at least in my case, is hosted on your local SQL Server Express....
- 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....