Open-source distributed OLAP database and powerful SaaS counterpart shine with plug-in indexes, signature tunable star-tree ...

A common SQL habit is to use SELECT * on a query, because it’s tedious to list all the columns you need. Plus, sometimes those columns may change over time, so why not just do things the easy way?

In this two-part series, I'll tell you about some improvements Microsoft is making in SQL Server 2022 to improve cardinality estimates and deal with another common query optimization concern ...

how to optimize a SQL ... query is issued for each root to find all the children in that branch. Then, the recordset is looped doing processing as required with a recursive function to build the tree.

I’ve created a script that monitors a table in a SQL Server database. I’m only interested in one column in the table: TimeStamp. If the maximum (newest) value in TimeStamp is more than 30 ...

Dynamic SQL lets you create a query string based off of user input. SQL Server allows you to create dynamic SQL statements. The statements use a SQL string varchar data type, then you execute the ...

Having a POCO class makes it easy to add those methods, or others that you find useful. Any hint of dynamic T-SQL queries should ring warning bells for security minded developers. Dynamic queries are ...

Honestly, we’ve often thought about writing something that parses C code and stuffs it into a SQL database. This tool leverages the CLang parser and lets you write queries like: That’s a bit ...

In part 1 of my SQL Server 2022 features series, you learned about the improvements to the cardinality estimator component of query optimization. In this installment, you will learn about another ...