Part of the SQL Server 2022 blog series. The main difference between tempdb and other databases is the workload. With tempdb we are constantly creating and destroying objects such as temp tables. This ...

Is your feature request related to a problem? Please describe. I wish to write SQL queries/questions that optionally return some rows. For example, consider a table where no entries are ever deleted.

SQL Server's OpenJson function will let you dismantle JSON structures into relational tables, including tables with foreign/primary key relationships. As I noted in an earlier column, JSON is great ...

The indexes on a the tables of a large database make a huge difference in its performance and utility. Without an index, locating a single record in a large table can take several seconds; with the ...

When you create a SQL question with parameters tied to fields that both have the same name (e.g. ID in two different tables), when you go to apply a dashboard filter to the tile, you can't tell which ...

I've said it before and I'll say it again: If you want to speed up your application, don't look at your code, look at your data access. The two slowest things you can do in application development are ...