T-SQL

At some point, every SQL developer or DBA will need to debug T-SQL scripts, either to verify that they behave as expected or to track down the root cause of a problem. Whether you’re building something new or investigating a production issue, debugging is an essential part of the process. There are several techniques available […]

If you’ve been working with T-SQL scripts for a while, you’ve likely encountered variables. These are essential for writing scripts that go beyond basic SELECT, INSERT, UPDATE, or DELETE statements. Variables can serve multiple purposes: they can act as parameters passed into stored procedures, hold the results of one query to use in another, or

When starting out with SQL Server, it’s important to focus on learning the basics to avoid getting bogged down with detail but there comes a time when knowing about the internals of a database page can be useful. Lets have a look at how SQL Server groups database pages and what they actually contain. What

When working with SQL Server, there are times when we need to insert a large number of rows into a table. This might be to populate test data in a non-production environment or to pre-load a new table with data from another system. There are several methods to achieve this, but in this article, we’ll focus on the impact of using multiple INSERT statements.

SQL Server has been around for many years and does a pretty good job of optimising queries. While there are ways we can help enhance performance, there are also plenty to inadvertently degrade it. A common issue I often encounter occurs in queries across date ranges.

Explore possible causes of slow deletes in SQL Server

Lets start with something simple. I used to wonder why column aliases were valid in an ORDER BY clause, but not in a WHERE clause. It took me a few years to actually look this up and find out what’s going on, so today I’m sharing the answer with you in the hope it gets