Mala Mahadevan

Querying database schema using graph tables

SQL Server 2017 introduced the concept of graph data tables as part of the SQL Server database engine. With SQL Server 2019, there were some enhancements like ‘shortest path’ function and constraints on edge tables that make this feature more usable – although it is far from a full-fledged graph database. Graph tables are essentially […]

5 (4)

2019-12-23

12,023 reads

Graph – Shortest Path

‘Shortest path’ is by far the most feature of SQL Graph for now. What does this even mean? ‘Shortest path’ is the term accorded to the shortest distance between...

2019-10-08 (first published: )

458 reads

Simple Graph Queries

In this post we saw how to create some graph tables with data. In this I will explore simple queries off of this data and how they compare with...

2019-10-01 (first published: )

419 reads

Blogs

Actual Difference Between EXISTS(SELECT 1 …), EXISTS(SELECT * …), and EXISTS(SELECT column …)

By

Is EXISTS(SELECT 1 ...) better than EXISTS(SELECT * ...)? Who would know better than...

ANSI_WARNINGS = OFF can break update statements with some SQL features

By

Working on a SQL 2017 database where an external, non-Microsoft application has direct access...

Bring Your Own Key to Azure SQL Database Managed Instance TDE

By

Last year Azure SQL Database Managed Instance saw the introduction of bring your own...

Read the latest Blogs

Forums

Towards an efficient interface between application and database

By Phil Factor

Comments posted to this topic are about the item Towards an efficient interface between...

How to handle date on temp table when is null or not ?

By ahmed_elbarbary.2010

How to handle date on temp table when is null or not ? I...

Recruitment question

By mcmiller1986

Thanks for fielding this question in advance: We are searching for a Microsoft SQL...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers