Efficient SQL performance is crucial for the smooth operation of any database-driven application. Slow queries can lead to longer load times, hampering user experience and reducing overall efficiency. This blog…
SQL Performance Strategies
Mastering the SQL Left Join
SQL is a versatile language for managing and manipulating databases, and one of its most powerful features is the ability to join tables. The LEFT JOIN command in SQL is…
Mastering the SQL Inner Join
SQL, the language of databases, is a foundational tool in the arsenal of anyone working with data. Among its various commands, the INNER JOIN is critical in efficiently retrieving and…
SQL Execution Plan
What is one? An SQL Server execution plan helps investigate performance issues with queries. As Database professionals, we receive user complaints that systems run slowly. Query results that used to…
Why is SQL slow?
Performance matters Ensuring your applications run quickly is vital in an age where users expect immediate results. Most modern computers are high-speed - smoking fast - even compared to machines…
Generate a C# class from a SQL Table
Background Most of the systems I have worked on are Database First applications. Either the team or SQL experts define the database first - or it has existed for years…
Used Identity Fields in SQL
What are identity fields? Like most database systems, SQL Server can define numeric fields as Identity fields. This means the database server automatically sets the numeric field value to the…
Who is using my database
Background Whenever users report that a system is slow, there can be many reasons. It can also be several different problems causing the system to be slow. However, more often…
Find duplicate records in a table and remove them
Why duplicates? It is surprisingly easy to inadvertently create duplicate records in a table. More often than not, it is because we either didn't check for an existing record or…
SQL Number of records per table
Do you know? There are lots of reasons why you might want to know how many records there are in your database tables. One of the most common is because…