Category: SQL

Monitoring query performance is an essential aspect of proper database management. Poorly performing queries can produce a domino effect, affecting the overall health of your database server and severely degrading application user experience. Queries that result in many reads and writes to the hard disk and that use excessive amounts of CPU time and memory…

When working with a SQL Server database, I often find it helpful to have a SQL query to hand that can be executed to tell me how many rows exist within each database table. This can be useful in scenarios where records are being inserted into lots of tables and you need to check that…

Have you ever installed an instance of SQL Server onto a new workstation or server and subsequently realised that you forgot to rename the machine first? In these cases, you’ll likely have installed both SQL Server and SSMS (SQL Server Management Studio). After launching SSMS you happen to notice that the ‘Server name’ field is…

Whenever I’m analysing the performance of a SQL Server database, I often find myself needing to retrieve a list of all indexes for review. Missing or unsuitable indexes are a leading cause of SQL Server slowdowns, so it can be very useful to view the existing indexes to get an idea of how heavily indexed…

Sometimes when working with a SQL Server database, you need to update a specific table row or insert a new row if the one you were trying to update isn’t already there. This logic is known as an ‘upsert’ operation i.e. either update or insert a row depending on whether it currently exists. In this…