Tech blog with tips, tricks and hacks
for EVs, hardware, software, home automation, programming and more
Whilst creating an application, which works from a central job list, I found myself wanting to perform both a select and update query at the same time. Essentially, marking jobs as collected, at the same time they are collected. This then allows me to run multiple instances of the same app, all picking up their
If you have a large table of data in a SQL server database, and you want to add a new index, but can’t afford to lock the table, then this article will help you. However, please note: This does does actually lock the table still, but only briefly. This will not work with SQL Server
If you run a busy SQL server an experience performance issues, there are several things you can do to diagnose issues. I’ll ignore the obvious ones for now (ensuring your queries are streamlined and using the SQL Profiler) and will provide you with an additional script to run which will give you a view of
If when using Microsoft SQL Server Management Studio to amend a table you encounter a dialog box saying: Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can’t be re-created or enabled the option prevent saving