From time to time there is a need to remove a large amount of data from the MS SQL table. By large amounts, I mean that the table contains a…
Tag: databases
There are situations when the SQL server is getting wild – mostly because of our own actions or poorly written queries. From time to time we notice that the SQL…
I noticed a strange error recently. When trying to access the properties of the MS SQL database using the Microsoft SQL Server Management Studio, I received this error: “Cannot show…
We noticed a strange issue when working with MySQL in ColdFusion. The date and time in the database field were set to ‘2020-01-10 00:38’ but when it reached our web…
For my pet projects, I’m using SQLite a lot. The database engine is fast, small and serves well for small amounts of data. What is most important for me –…