Understanding the difference between search queries and keywords is the key to creating search strategies that work.

SQL databases with in-memory column stores, NoSQL with query languages; it looks like the two schools of database design have begun to merge.

One of the most common problems when running SQL Servers is slow queries. The help desk or database team usually hears that described as the application is slow or the database is slow. In the ...

Want faster SQL queries? Here are nine best practices for writing SQL queries that work like a charm (or at least, like they should).

As I discussed in an earlier column, SQL Server keeps a plan cached for each query it sees (assuming the query requires planning in the first place, of course). That's great for speeding up processing ...

The Microsoft SQL Query Analyzer is part of the client tools that come with Microsoft SQL Server 2000 Enterprise Edition. It's designed to analyze the SQL queries that you or a program makes that ...

For years now there's been a constant war between Microsoft supporters and Oracle supporters. Oracle has these features, SQL Server has these features, etc. But that's not really where the real ...

Check out every entry in the series to date. A question so seemingly simple as “what’s the difference between bourbon and scotch?” is actually asking something else entirely.

Graph analytics is a hot topic, but what does it mean? At the DC GraphTour, I learned the difference between graph queries, graph algorithms, and graph analytics. Next up: San Francisco GraphTour.

One of the most common problems when running SQL Servers is slow queries. The help desk or database team usually hears that described as the application is slow or the database is slow. In the ...